[AccessD] Input Mask for Date Format

[Steve Schapel]

Hi Rocky

I have two suggestions, which are a bit contrary to the user's current 
viewpoint.

1.  Put the date and time in 2 separate fields.

2.  Forget the idea of an input mask for dates.  It makes data entry more 
difficult with no benefit.  Access allows you to enter the date in any way 
you want, and then display it as per the format you specify for the control. 
As you know, Access stores the date as a long integer, which is exactly the 
same regardless of the format of data entry.  A few minutes of staff 
training is way better than trying to pointlessly shackle them.

Just my 2c.

Regards
Steve

-----Original Message----- 
From: Rocky Smolin
Sent: Friday, August 7, 2015 6:48 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Input Mask for Date Format

Dear List:

Having a problem generating an input mask for a text box that is bound to a
date/time field (I always have problems with the input mask).

The user wants MM/DD/YYYY hh:mm

Any suggestions greatly appreciated.

MTIA,

Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/>
www.e-z-mrp.com <http://www.e-z-mrp.com/>
Skype: rocky.smolin

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com