textbox validation

[endri81]

How to validate a textbox in order to accept only integers from 1-20 and in all the other cases show a message box for non accepted values?

 

[Rabbie]

And what do you want in the text box if an invaid entry is made?

 

[endri81]

Rabbie:Smthg Like sorry only numbers from 1-20 allowed.

 

[JANR]

Put this in the control's BEFORE_Update event

Private Sub [COLOR=red]NameOfControl[/COLOR]_BeforeUpdate(Cancel As Integer)
If (Me![COLOR=red]NameOfControl[/COLOR]) > 0 And (Me![COLOR=red]NameOfControl[/COLOR]) < 21 Then
    ' do nothing
Else
    MsgBox "Wrong Format, choose numbers between 1-21"
    Cancel = True
    Me![COLOR=red]NameOfControl[/COLOR].Undo
End If
End Sub

Change the marked in red to the correct name of your control

JR