Hide all empty fields in a report

[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

 

[Jim/Chris]

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

Jim

 

[Arvin Meyer]

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.

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

 

[Patti]

Thanks I'll give it a try
Patti

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