Avoid date errors

Table Properties in Microsoft Access

One of the better ways to avoid date errors in Microsoft Access is the use the table properties feature. In table properties you can set up a validation rule and display validation text. This method restricts how data is entered at source.

Avoid date errors

By default, the data type in Microsoft Access is Short Text. Data types must reflect the data use, for examples if dates are entered the data type is usually set to Date/Time, otherwise date errors may occur.

Date Type Mismatch

If a Short text field is used in a query as part of a calculation an error message is generated. The fix for data type mismatches is done at table level. Using data validation rules at field or table level stops data type mismatches but only if the data type is set correctly. Data Validation is one of the better ways to avoid date errors in Microsoft Access.

Avoid date errors with Field Properties

As with Table properties, Field properties provide validation rules as well. This area is used to stop incorrect formats being entered but cannot be used to check around a table. Field properties display format options for several data types. The date formats are short date and long date. Once set, a date format displays either one or the other. To restrict date entries the properties area has an input mask feature. The input mask restricts date entries to the mask set. For examples 21 August 2022.


For Course details, search here.

Online courses, search here.

Buy training sessions online, classroom based or via Microsoft Teams. All courses come complete with training manuals and examples.

Leave a Reply

You must be logged in to post a comment.


“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd

“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services

“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA

“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group