Printing "No Data"

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

Hi, I am new to Access and VB but i have written a report that seems to
work fine but if there is no data to show in the detail section of the
report it just shows a blank line. Is there a way i can have it print "No
Data" in the detail section of the Report instead of the blank line?

If anyone can assist please do. and as always, THANKS IN ADVANCE!!!!

-Chip-
 
You can add a text box to the Report Header Section with a control source
like:
=IIf(HasData,"","No Data")
 
This does not seem to be working as the header has data just the detail
section is Blank.
Did i miss something?
 
OOPS, i mean that my report when it is ran has data only the detail section
needs the "No Data" statement. I may have misunderstood your reply...
 
Back
Top