report with several unbound fields

  • Thread starter Thread starter Timmy
  • Start date Start date
T

Timmy

I have a report that has several unbound fields. If one particular field is
blank I want the whole report to be blank in print preview
 
Tim,
This might work.

Left click on the footer or section you want to be invisible
Click on event
Open "On Format"
Click code builder
In the code loop through the fields you're checking for null
If all null then set the visibility property to each section to not visible
I didn't test it but it should work
 
Back
Top