I cant set a number between 0-1 for my textbox

[zaza123]

I knw its basic but i cant set my textbox to only allow numbers to be keyed in to be 1 & 0....I need a textbox that only allows Number 0 & 1 to be inputed when any other no are inputed, A message Box will Pop Out And say " Input No From 1 & 0" ....Pls

[apr pillai]

1. Open the Form with the Text Box in Design View.
2. Select the Text Box
3. Display it's Property Sheet (F4).
4. Find the Validation Rule Property and type: >-1 and <=1
5. In the Validation Text Property type: Valid Values 0 and 1 only
6. Save the Form and open it in normal view.
7. Try entering any numeric value other than 0 and 1 to test.

[zaza123]

Thx i knw i can change from the validation rule but i need a message box to pop out saying either number 1 or 0....Thats y i wrote a VB code here u can have a look at it...

Here is the code

Dim H As Interger
Private Sub Text20_KeyUp(KeyCode As Integer, Shift As Integer)
H = 1 And H = 0
Text20.Text = H
If Text20.Text Then
Else
Text20.Text = ""
MsgBox ("Numbers from 1 to 0 or just leave blank")
End If
End Sub

[apr pillai]

The Validation Text Property Value serves the same purpose of a Popup Message. When the value input into the Textbox is not within the Validation Rule whatever you write in the Validation Text will appear as a message box. It can be validated through VBA Code too. It is a matter of preference.

[zaza123]

Thx alot man!!!!!