How to error check EditBox?

[count]

Hi,
I tried this in a form that's called from another:
Private AgeBox_Change() 'AgeBox is a TextBox control
If val(AgeBox) > 150 then
AgeBox.SetFocus
End If
And it gladly ignores my intention to halt user in the box to correct the
number.
I also tried that logic within other events: Enter, BeforeUpdate,
AfterUpdate, Exit. No luck.
I really need to error check for numeric, for no garbage and within range.
How is it done?
BTW: I prefer, if possible, not to use message boxes with bad news - just
plain halting in a box will do.
Thanks
Paul

 

[Tom Ogilvy]

It is probably easier to not permit entry besides numbers:

check out Harald Staff's posts in this thread:

http://groups.google.com/groups?threadm=#[email protected]

You can also add a check for the value of the entry if you need to.

 

[count]

Thanks Tom - answers me 100% !
Paul
----------

It is probably easier to not permit entry besides numbers:

check out Harald Staff's posts in this thread:

http://groups.google.com/groups?threadm=#[email protected]

You can also add a check for the value of the entry if you need to.