Solved

access form numeric only

Posted on 2014-04-12
3
497 Views
Last Modified: 2014-04-12
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
0
Comment
Question by:Rayne
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 39996551
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
 

Author Comment

by:Rayne
ID: 39996593
Thank you  hnasr :)
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39996607
Welcome!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question