Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text boxes on screen not on hardcopy

Status
Not open for further replies.

teebird

Technical User
Dec 11, 2001
239
Hi Everyone

When I printpreview my report - the dates are displayed but when I print a hardcopy there is printed #Name? where my Dates should have printed.

I am using this code in my query to get the dates
Is Not Null And Between [Forms]![frmReports]![BeginningDate] And [Forms]![frmReports]![EndingDate]

and this code on my report to display the dates.

=[Forms].[frmReports].[BeginningDate]

Any suggestions would be great. thanks

Tee
 
Is that form open when you print the report?

Also if you are not to sure about the syntax for =[Forms].[frmReports].[BeginningDate] then use the expression builder to do it. Sometimes not having brackets around 'Forms' or having a '!' instead of a '.' sometimes helps.

wah

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top