Report - Conditional Field Format

[whitjl143]

I have two fields:

Material
LoadAt

I want the LoadAt field to print if the Material field is "Haul Only". I
don't want the LoadAt field to print if the Material field says anything else.

Thanks so much!

 

[fredg]

I have two fields:

Material
LoadAt

I want the LoadAt field to print if the Material field is "Haul Only". I
don't want the LoadAt field to print if the Material field says anything else.

Thanks so much!

These controls are in the Detail section?
Code the Detail Format event:

Me.[LoadAt].Visible = Me.[Material] = "Haul Only"

Alternatively, you could use an expression in an unbound control (and
not use code at all):

=IIf([Material] = "Haul Only",[LoadAt],"")

 

[whitjl143]

This is not working. It might be because the control source of the LoadAt
field is:
=[Material].Column(2)

Will that mess it up?

--
Jenn

I have two fields:

Material
LoadAt

I want the LoadAt field to print if the Material field is "Haul Only". I
don't want the LoadAt field to print if the Material field says anything else.

Thanks so much!

These controls are in the Detail section?
Code the Detail Format event:

Me.[LoadAt].Visible = Me.[Material] = "Haul Only"

Alternatively, you could use an expression in an unbound control (and
not use code at all):

=IIf([Material] = "Haul Only",[LoadAt],"")