dependancy of text box visibility 1

[Cordeiro82]

Hello All,

How would you make the visibility of txtboxA dependant on a value in txtboxB, so that txtboxA is only visible when txtboxB displays the value "Yes".

thanks,

kevin

 

[jebry]

Hi!

Use Conditional Formatting from the Format menu.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[missinglinq]

Set Visible to False in the Properties Box for txtBoxA, then:

Private Sub txtBoxB_BeforeUpdate(Cancel As Integer)
   If txtBoxB = "yes" Then txtBoxA.Visible = True
End Sub

Private Sub Form_Current()
  If txtBoxB = "yes" Then
    txtBoxA.Visible = True
  Else
    txtBoxA.Visible = False
  End If
End Sub

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[PHV]

Private Sub txtBoxB_BeforeUpdate(Cancel As Integer)
txtBoxA.Visible = (txtBoxB = "Yes")
End Sub

Private Sub Form_Current()
txtBoxA.Visible = (txtBoxB = "Yes")
End Sub

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886