Correct info on Report but "#Name?" on Printout

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Greetings,

I have designed a report that calls for the user to input
the Start and End date of the information to be detailed
in the report.

I have put an expression in a header that informs the
user "Report period from ..StartDate..through..EndDate.."
based on their input.

It shows the correct dates upon generation but when I
export or print the report the expression turns
to "#Name?"

Does anyone have any experience with this? IT IS DRIVING
ME CRAZY!!!!!

Thanks so much,

ADam G
 
Suggestions:

1. Are the value dependent on text boxes on a form? If so, has the form been
closed, so the values are no longer available when the report is printed?

2. What exactly is the Control Source of this text box on the report? Try
explicitly formatting the dates (which also typecasts to string):
="Report period from " & Format([StartDate], "Short Date") & " and " &
Format([EndDate], "Short Date")

3. If neither of these solve the problem, try adding text boxes for
StartDate and EndDate to the report. You can set the Visible property to No.
 
Back
Top