Disable textboxes

A

anb001

I have three text boxes in a form. As soon as I enter a character in one
of the textboxes, the other two should be disabled. If I then delete
whats in that textbox, so it is 'empty' again, the other textboxes
should be enabled again.

What should I do?
 
B

Bob Phillips

Private Sub TextBox1_Change()
TextBox2.Enabled = (TextBox1.Text = "")
TextBox3.Enabled = TextBox2.Enabled
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top