Textbox - validation rule numbers only - Msgbox

[Lukael]

Hi,

I have set Format property of Textbox for numbers only. When I enter something else, Access opens Msgbox "Value you entered isn't valid". Is there any non-VBA property to make Custom Msgbox for that?



I tried with Validation rule >0 property, and entered my own Validation Text, but that doesn't work.

[JoeM]

You could use a "Before Update" or "On Exit" event, something like was done in the following two links:
http://www.mrexcel.com/forum/microso...ox1-form1.html
http://answers.microsoft.com/en-us/o...c17db68?auth=1

[Lukael]

thanks Joe,

this did the trick :

Private Sub txtNumbersOnly_BeforeUpdate(Cancel As Integer)
If Me.txtNumberOnly.Text Like "*[!0-9]*" Then
   MsgBox "You can enter only numbers in this field !"
   Cancel = True
End If
End Sub