report with several unbound fields

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
 
J

J

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
 
T

Timmy

I'm not that that good with the code and I only need to chek one field.
Thank you
Tim
 
Top