hide textbox if another contains a certain value

K

kim

Hi, I'm using Access 97.

I would like to know if it is possible to hide a certain
textbox along with its label ONLY if a different textbox
contains a certain value.

thanx in advance
 
D

Duane Hookom

You can use code in the On Format event of the section containing the
controls.

Me.txtCertain.Visible = Me.txtDifferent = "Certain Value"
Me.lblCertain.Visible = Me.txtDifferent = "Certain Value"
 
Top