Invisible Header

  • Thread starter Thread starter Jeff Clarke
  • Start date Start date
J

Jeff Clarke

Is there a way to have an invisible header if a certain field is empty. I'd like to show a header section that says "None Found" only if there are no records within the report and if there are records within the report, I'd like to make the None Found Header to disappear.

Thanks,


Jeff
 
You first suggest "field is empty" then you state "there are no records
within the report". If you mean no records in the report record source, then
you can use a text box bound with a control source of:
=IIf([NoData],"None Found","")

--
Duane Hookom
MS Access MVP


Is there a way to have an invisible header if a certain field is empty. I'd
like to show a header section that says "None Found" only if there are no
records within the report and if there are records within the report, I'd
like to make the None Found Header to disappear.

Thanks,


Jeff
 
Back
Top