Print Preview ok - Print out shows #name?

[milly54]

Hi,
Using Access 2003 sp1, I have created a small form which allows the user to
select a date range to filter a report.

I've got the dates (along with all the data) to appear correctly in the
report preview, but when printed out, the date shows as #name?

Is it a bug or am I missing something obvious?

I'd appreciate any help/advice

 

[Allen Browne]

What is in the Control Source of the text box that has this problem?

If it is something like:
=[Forms].[Form1].[txtStartDate]
then check that the form is still open after the preview, at the time you do
the printing.

 

[milly54]

Allen - Fantastic!
Some while back I included a line to close the "date-select-form" after
clicking "go", so that it cleared the users desktop.

Your suggestion led me straight back there. The form closed before spooling
had completed, and lost the date-data - hence the printout had nothing to
display.

I've removed the line, tested it and prints ok now.

Brilliant - thank you!

Martin

What is in the Control Source of the text box that has this problem?

If it is something like:
=[Forms].[Form1].[txtStartDate]
then check that the form is still open after the preview, at the time you do
the printing.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi,
Using Access 2003 sp1, I have created a small form which allows the user
to
select a date range to filter a report.

I've got the dates (along with all the data) to appear correctly in the
report preview, but when printed out, the date shows as #name?

Is it a bug or am I missing something obvious?

I'd appreciate any help/advice