Showing "no data" on a report

[Spicealdous]

Can anybody help me???

I would like a report to show the message "Nill Returns" when I run a report, instead of showing a blank page or a page full of "Errors"

Any ideas as this is really bugging me!

 

[KenReay]

Hi

Probably more than one way to do this, but one idea is:

have a textbox control on the form, set it to visible if recordsource recordcount is zero, and set the content to "Nill Return", set other controls on the report to visible = false

if record count > 0 do the reverse

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[adsfx]

use the 'on no data' event of the report to show a message box eg.
MsgBox "There are currently no returns", vbOKOnly