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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top