Hide all empty fields in a report

P

Patti

How do I hide all blank fields in a report yet still show the ones
containg information? The table it is linked to will only have one
record in it at any given time.

Patti
 
J

Jim/Chris

Try this in the forms "On Current" event
Me.fieldname.Visible = Not (Len(Me.fieldname.Value & "") = 0)

Jim
 
A

Arvin Meyer

Patti said:
How do I hide all blank fields in a report yet still show the ones
containg information? The table it is linked to will only have one
record in it at any given time.
Click to expand...

In the OnFormat event of the Detail Section of the report, use a bit of code
like:

If Len(Me.txtBoxName & vbNullString) = 0 Then
Me.txtBoxName.Visible = True
Else
Me.txtBoxName.Visible = False
End If
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top