Report shows #Name? when printed but is OK in Preview

Hi, I have a report that displays the correct data in Preview but displays #Name? when printed. (Access 2003)

The field is unbound but the control source is read from a form

ie. it shows a date range in text that is formatted in the form after the user has selected a week number range from the two combo boxes, and then the contents of the combo boxes.

The dialogue form is kept open until the report close event and the contol width is ample for the text.

Has anybody any ideas why the error?

Many thanks

re: Report shows #Name? when printed but is OK in Preview

Do you get the same result if you put code in to just set the value of the text box?

re: Report shows #Name? when printed but is OK in Preview

Sorry Guys! My error!
The dialogue form was being closed from the 'Preview' command button (on the form) after the command to preview the report, so the data was not available if the user subsequently wanted to print the report.

Thanks anyway

re: Report shows #Name? when printed but is OK in Preview

You had me confused there Sierra. Now it makes sense :)