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

Arthur,

I set the input mask to ##/##/## and that works nicely.

However, when I did this, I lost the use of the built-in date picker for
this field.

Maybe I am missing something here.

Thanks,
Brad

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, April 05, 2012 1:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Question on a Date Field that is Input on an
AccessForm.

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
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.