?
Solved

access form numeric only

Posted on 2014-04-12
3
Medium Priority
?
512 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 2000 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 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