#Name? in text field

[Guest]

If I use:
DoCmd.OpenReport Reportname, acViewPreview
I get #Name in a text field both on the screen and on the print out.

If I use:
DoCmd.OpenReport Reportname, acViewNormal
I do get the field to print correctly.

I want the user to be able to view the printout before going to the printer
so the first option above is what I am looking for.

Please help Thank You!

 

[Allen Browne]

Open the report in design view.
Right-click the problem text box, and choose Properties.

What is in the Control Source property? It sounds like Access is having
problems identifying the field or the items in the expression.

Also check the Name property. If the control has the same name as a field,
but it bound to something else, Access gets confused.

The fact that it works in normal view but not if you preview suggests there
could be other possible issues as well, such as data types being
misunderstood, or code that is not working as expected, or a Name
AutoCorrect issue.