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

Arthur Fuller fuller.artful at gmail.com
Thu Apr 5 13:22:52 CDT 2012


Set the input mask to ######. That should do it. Format controls how it
looks; InputMask controls how it's entered.

HTH,
Arthur

On Thu, Apr 5, 2012 at 2:15 PM, Brad Marks <BradM at blackforestltd.com> wrote:

> 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