HIDING BLANK FIELDS IN REPORTS

  • Thread starter Thread starter executive514
  • Start date Start date
E

executive514

I have an access report that has some blank fields. I would like those
fields to show on the report only if there is data in the field. How can I
do this?
 
executive514 said:
I have an access report that has some blank fields. I would like those
fields to show on the report only if there is data in the field.
Click to expand...


Add code like this to the section's Format event procedure:

Me.somecontrol.Visible = (Nz(Me.somecontrol, "") = "")
 
Back
Top