access form numeric only

Hello all,

I have several fields in a table that I am letting users fill in via a form. Now what kind of event i do in the form within so that if I enter non numeric vlaue for that field in the form, it pops up a message saying "no can do"

Thanks
RayneAsked:
Who is Participating?
 
hnasrConnect With a Mentor Commented:
If table field is numeric, then a form field bound to that field, won't accept entry of that field unless numeric.
If form field not bound, then set Format Property to: 0.0
0
 
RayneAuthor Commented:
Thank you  hnasr :)
0
 
hnasrCommented:
Welcome!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.