Conditioned Text Fields

[Firesaferescue]

Hi everybody,

I am trying to hide a number of text fields on a report when a certain control has a value ZERO.

Does anybody knows how to do so, because by selecting the control, right click shows "conditional formatting", but it is not possible to relate this to another control.

TNX!

 

[lution]

See: http://www.access-programmers.co.uk/forums/showthread.php?t=139645&highlight=report+hide

 

[ahuvas]

If Me.Control1.Value = 0 then
Me.Text1.Visible = False
Else
Me.Text1.Visible = True?

 

[pbaldy]

And for the record, you can relate to a different field using Conditional Formatting. You just have to use "Expression is" instead of "Field Value..".