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