Sorry for this likely noob question but I cannot seem to find the solution. I'm trying to modify an existing field on a report, standard in this field the data is being pulled from the control source Insert under the properties pane and looks fine. I'm trying to change this into a 1D barcode which requires * before and after. I check the syntax for concating strings with inputs and it should be = "*" & [Insert] & '*" but this just throws a #Type! error on the report when it's viewed. What am I doing wrong?

  • Can you show the full expression and the full error string? – PollusB Dec 17 '19 at 16:32
  • Under the properties sheet, Control Source I literally have typed ="*" & [Insert] & "*" and when you go back to view the report out of design mode it says #Type!. There is nothing else, where as if I only have Insert typed there, it populates the data fine – 55thSwiss Dec 17 '19 at 16:34
  • sounds like there might be formatting for the field in the report that is incompatible with non-numeric characters. – Max Vernon Dec 17 '19 at 16:34
  • 2
    Name of control isInserttoo? Then change name, otherwise you create a circular reference, see social.msdn.microsoft.com/Forums/office/en-US/… – ComputerVersteher Dec 17 '19 at 17:51
  • 2
    @55thSwiss Please put your resolution in an answer, then accept the answer, so that this question can provide value to our community. – Randolph West Dec 18 '19 at 0:28

As the users in the comments above pointed me in the right direction, the issue was a circular reference error between the name of the created field (TextBox) and the Control Source. These can be viewed in the Property Sheet of a form or report under All tab. Obviously you don't want to rename the Control Source between this references the table or query the data's being pulled from, so just change the name of the text box. For whatever reason MS Access defaults with the names being the same so this is a common issue. In the image, originally the fields Name and Control Source both contained Insert.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.