Hide a text Box!

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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







..........Jenny Vance
 
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.


Bob said:
Oops Sorry on a Report...Thanks bob

Bob said:
Is it possible if text box: [tbone] has not data in it that [tbtwo] will
be hidden.... Any help Thanks bob
Click to expand...
Click to expand...
 
Thanks Allen, But Null didn't work but this did:
=IIf([tbGSTOptionsValue] = 0, Null, [GSTNoLable])

Thanks Bob



Allen Browne said:
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.


Bob said:
Oops Sorry on a Report...Thanks bob

Bob said:
Is it possible if text box: [tbone] has not data in it that [tbtwo] will
be hidden.... Any help Thanks bob
Click to expand...
Click to expand...
Click to expand...
 
Back
Top