HIDING BLANK FIELDS IN REPORTS

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?
 
M

Marshall Barton

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, "") = "")
 
Top