Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No Data Event

Status
Not open for further replies.

monsterman66666

Programmer
Jan 17, 2002
8
US
I am using ACCESS 2000 VBA.

I am trying to display a message in a field within my report that does not return any data.
CAN ANYBODY HELP PLEASE!!!
 
Well, in your specific controls data source property (I assume your using a text box), put something like this:

=Iif(IsNull([the_data]),"Show no data returned message",[the_data])

Hope this is specific enough, good luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top