Suppressing blank fields in a report

  • Thread starter Thread starter Tijut
  • Start date Start date
T

Tijut

I have been unable to find any information regarding the
above. I have 40 fields for each person and only want to
display the fields that have entries on my report. Can
someone point me in the right direction?
 
Tijut said:
I have been unable to find any information regarding the
above. I have 40 fields for each person and only want to
display the fields that have entries on my report. Can
someone point me in the right direction?
Click to expand...


Not sure I follow that, if a field is Null, a text box
(control) bound to the field will not display anything other
than it's border and (if present) its attached label. If
that's what you want to get rid of, then add code to the
section containing the control to make the control
invisible:

Me.thiscontrol.Visible = Not IsNull(Me.thiscontrol)
Me.thatcontrol.Visible = Not IsNull(Me.thatcontrol)
Me.othercontrol.Visible = Not IsNull(Me.othercontrol)

If the controls are not displaying anything, just taking up
vertical space, then set the control's and its section's
CanShrink property to Yes.
 
Back
Top