Print Report with No Records

[sinyce]

Every day I print a Report based upon a query. Some days the query returns no records, which I still want to print, but with a big text box or image file that says: "NO ENTRIES TO LOGFILE" somewhere in the middle of the page.

I've tried to put a text box in the middle and set Visible=No, then use the form On NoData option to set it to visible, but it disrupts the report layout when there is data.

Any help would be appreciated.

Sinyce

 

[JoanneM]

Don't Laugh

I had this problem and in the end I just created a dummy report with exactly what you have and on NO Data I printed that one instead. I just copied my original deleted all the bumf and put the text box on and ended the problem - not elegant and whizzy but quick and resolved.

regards


Jo

 

[sinyce]

Joanne:

Guess what, I didnt laugh and it worked just like a charm. Did exactly like you said...duped the report, deleted the field name and just placed a text box with my message. Attached that to the On NoData Event. and voila!

Thanks. At least it beat screwing around the idea for half a night.

Sinyce