Printing #Name? error

[LongTown]

I have a report text box that is controlled by an unbound form text box (i.e. I write dates in it). Up until about a month ago this process worked quite well. Now, the report text box on print preview displays this information correctly but on printing the report the place where preview displayed it shows the error #Name?. The formula I used for the report text box: =Forms![Dep Entry]!Text41

 

[PHV]

Is the [Dep Entry] form still open when the report is printed ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LongTown]

No, I use a macro to close it when the report opens

 

[dhookom]

If the form is closed, how do you expect your report to display the value? Keep the form open or find a different solution.

Duane
Hook'D on Access
MS Access MVP

 

[LongTown]

The printing worked very well for several months prior to this problem. I did change the macro so the form didn't close. The printing result gave the same error.

 

[dhookom]

When the report is open and displaying the same error, open the debug window (press Ctrl+G) and enter:

? Forms![Dep Entry]!Text41

What do you get returned? If it is the proper value then your report has an issue. If the proper value isn't returned or you get some kind of error then you have an issue with the expression such as the name of the control or similar.

BTW: Text41 is not a good name. You really should take the time to change it to something meaningful.

Duane
Hook'D on Access
MS Access MVP

 

[LongTown]

I changed the view when opening the report to print instead of print preview and I get the results that I expected. It's not exactly like I wanted it but it works. Thanks for all the suggestions. I also changed the text41 name.

 

[dhookom]

Do you have code in your report that closes the form? If so, change or delete it so the form remains open even if the report closes.

Duane
Hook'D on Access
MS Access MVP

 

[LongTown]

I did. Thanks

 

[dhookom]

Apparently this is working now or do you still have issues?

Duane
Hook'D on Access
MS Access MVP

 

[LongTown]

I'm good