Solved

Input mask error trapping

Posted on 1998-03-19
1
212 Views
Last Modified: 2008-03-06
I have an input mask on the form , for example to force user to  enter for digits for the year, how can i trap an error that Access produces, when entry not apropriate to the mask is done?
0
Comment
Question by:pvs001d
1 Comment
 
LVL 3

Accepted Solution

by:
guillems earned 100 total points
ID: 1971228
In the form there's an event ON ERROR, in this event, you'll go when the form makes an error

So in this event you must trapping the errors

I hope this help you!

PS. If you need more information, See the help (event ON ERROR)
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
hit enter key to run macro 13 23
How can I create a Message box thru a Macro action for yes / No? 26 56
Create report using crosstab query 11 29
Should I keep recordsets open? 3 23
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

806 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