[AccessD] Question on a Date Field that is Input on an Access Form.

Brad Marks BradM at blackforestltd.com
Thu Apr 5 13:15:59 CDT 2012


All,

I have a data field on an Access 2007 form.

It is set up with Format = Short Date 

Show Date Picker is Turned On.

Some users like the Date Picker.  This works nicely for them.

Other users, however, want to key in dates (without slashes) such as
040512.

I would like to accommodate these users by using VBA code to insert
slashes as needed.

040512 would become 04/15/12 for example.

When a date is entered as 040512 the user receives this error message -

"The value you entered isn't valid for this field."

Is there some way to intercept the field and add slashes before the
error message is sent?
(and still keep the field as a date field in order to have the date
picker for the users who like to use the date picker)

Thanks,
Brad   



More information about the AccessD mailing list