Make field visible in Report Depending on its Value

[firsttube]

Is it possible to make a field of a particular record in a report visible depending on it's value?

eg.

if field = 0 then "do not show it on the report"

thanks

ft

 

[THWatson]

firsttube
In the Properties for the Detail section of the report, put the following code in the Format event.

If Me.YourControlName = 0 Then
Me.YourControlName.Visible = False
Else
Me.YourControlName.Visible = True
End If

Check the name of the control that pulls data from the field in question...that's what you put where I have showed YourControlName.

In tables they are called fields. In forms and reports they are controls and text boxes.

Tom

 

[firsttube]

that did not work. I stripped it right down to just:
Me.ControlName.Visible = False

and it still showed the control.

any ideas

thanks

ft

 

[dhookom]

Try:
Me.ControlName.Visible = Me.ControlName <> 0

Duane
MS Access MVP
Find out how to get great answers faq219-2884.