Hide field when txt input

[kbp]

I am not so good at VBA with excel, so can someone help me please. I have two fields a) Customer number (named as txtCust) and b) Account number (named as txtAccount). I want to write code, if anything entered in customer number field, account number should be disabled and vice versa. So only one field to be allowed to enter at one time.

[mudraker]

Need more information

Are these on a form?

[kbp]

Yes they are on a form as text fields.

[mudraker]

You will need coding for each txt box

Code disables the other txt box if it has an entry in it & also changes the txtbox colour so that it is not as enticing for a person to select it.
Another option would be to hide the textbox using the visible setting instead of changing the colour


A list of colours can be found at http://dmcritchie.mvps.org/excel/colors.htm

Private Sub txtAccount_change()

If Me.txtAccount.Value = "" Then
Me.txtCust.Enabled = True
Me.txtCust.BackColor = RGB(255, 255, 255)
Else
Me.txtCust.Enabled = False
Me.txtCust.BackColor = RGB(192, 192, 192)
End If
End Sub


Private Sub txtCust_Change()
If Me.txtCust.Value = "" Then
Me.txtAccount.Enabled = True
Me.txtAccount.BackColor = RGB(255, 255, 255)
Else
Me.txtAccount.Enabled = False
Me.txtAccount.BackColor = RGB(192, 192, 192)
End If
End Sub