Hide a text Box!

[Bob]

Is it possible if text box: [tbone] has not data in it that [tbtwo] will be
hidden.... Any help Thanks bob







..........Jenny Vance

 

[Bob]

Oops Sorry on a Report...Thanks bob

 

[Allen Browne]

Set the Control Source of the 2nd one to an expression like this:
=IIf([tbOne] Is Null, Null, [tbTwo])

Make sure you change the Name property of the text box as well. Access gets
confused if a control has the same name as a field, but is bound to
something different.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Oops Sorry on a Report...Thanks bob

Is it possible if text box: [tbone] has not data in it that [tbtwo] will
be hidden.... Any help Thanks bob

 

[Bob]

Thanks Allen, But Null didn't work but this did:
=IIf([tbGSTOptionsValue] = 0, Null, [GSTNoLable])

Thanks Bob

Set the Control Source of the 2nd one to an expression like this:
=IIf([tbOne] Is Null, Null, [tbTwo])

Make sure you change the Name property of the text box as well. Access
gets confused if a control has the same name as a field, but is bound to
something different.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Oops Sorry on a Report...Thanks bob

Is it possible if text box: [tbone] has not data in it that [tbtwo] will
be hidden.... Any help Thanks bob