General discussion


XP ACCESS - dates

By Ckbtwy ·
in a data/time field setup for shortdate with an input mask - if I type 13/05/05 ACCESS returns 05/05/2013- obviously there is no 13th month - I thought that by using the Date/Time function - ACCESS would automatically verify for date accuracy - what do I need to do now, maybe write a validation rule (how/where (table/form etc)change my format, etc. so that an error msg will automatically pop up to notify the user that the date has been input wrong. This error also occurs in 97 and 2000. Any and all help is greatly appreciated by me and forever by my users. Thank you

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

XP ACCESS - dates

by grungemann In reply to XP ACCESS - dates

The simplest thing to do is to set the date field format to dd/mm/yy or whatever format you want in the table design.

Another way is to use the isdate function in the form's after update event.

Collapse -


by im_a_beginner In reply to XP ACCESS - dates

if you have table under the date the format should be shortdate and the validation rule should be date()... so that when you save your information to the table there is a message about the date....

Related Discussions

Related Forums