Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Input mask error trapping

Posted on 1998-03-19
1
Medium Priority
?
228 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 200 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

916 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