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
 

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

Similar Threads

If unbound list box in report is blank then don't show report deta 5
Problem with unbound fields value 2
Filtering subreports on main report 0
Print preview of Access 2003 report in Access 2007 2
bound vs unbound main report 3
Converting GPS coordinates to decimal in Report 0
Access Access Report Works on One Machine but not Another 3
Field Not Printing 6

Back
Top