hide textbox if another contains a certain value

  • Thread starter Thread starter kim
  • Start date Start date
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
 
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"
 
Back
Top