[AccessD] Input Mask for Date Format

[Rocky Smolin]

Steve:

I agree.  In fact suggestion one they did on Tab 1 of the 7 tab form.  On
tab 2 however, they want them combined!  User (sigh) you never know what
they're going to do next...

Suggestion 2 - That's too easy.  I'll pass that by them and see if I can
make that fly. 

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Steve Schapel
Sent: Thursday, August 06, 2015 2: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