[AccessD] Input Mask for Date Format

[James Button]

I believe that there will be several discussion threads in the archives about
using datepickers.
Definitely split the data into date and time fields
Also for verifying the date as entered has been correctly evaluated re-show any
entry as dd mmm yyyy 
So that it is clear what part of the input was used for day of month, and for
the year.

JimB

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve
Schapel
Sent: Thursday, August 06, 2015 10:28 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Input Mask for Date Format

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 

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