Appears in Preview, but not in Print (1 Viewer)

[JohnPapa]

In attached Preview.png I can see the Dates. When I print the report (Print.png) the dates are substituted with "#Name?"

In the report the date fields are bound to
Control Source =CDate([Forms]![frmTransactionPopup]![dtmFrom])

where frmTransactionPopup is a form which is open but not visible.

Any ideas welcome,
John

 

[vbaInet]

I don't see anything wrong with it so it should work. I don't think that the form is still open in form view.

 

[ConnorGiles]

Everything appears correct on this end John - i cant see a problem with print.png - the documents seem the same but obviously print.png has been copied

 

[ConnorGiles]

ohh now i see - the dates, try expanding the field sizes on design view sometimes its because the field size is too small so it subsitutes it for another value while the field size is too small for the full date.

 

[ConnorGiles]

if that doesnt work, would you be able to please zip your database and post it here so we can check for internal problems

 

[JohnPapa]

Many thanks for your replies.

It appeared that between Preview and Print the form was closed. I removed some of the form close statements and it now works. The form is opened acDialog BUT then it is made invisible and seems to be closed before Print.

Thanks again.
John

 

[ConnorGiles]

Glad it works

Enjoy

Connor

 

[vbaInet]

Good to hear!

 

[JohnPapa]

Is there a way to mark as ANSWERED?

 

[vbaInet]

On your first post you'll see a button called "Thread Tools". Have a look there.