Solved

access form numeric only

Posted on 2014-04-12
3
498 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

733 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