[AccessD] Date standardization

Hi Jim,

Are you talking about the way the dates are entered?  If these data is going 
into a Date/Time data type field, then I think it doesn't make any 
difference at all how the dates are entered, as long as it is a format 
recognised as vaid by your regional settings.  The Format of the control 
where the dates are entered/displayed will determine how they are shown 
after they have been entered, but unless you do cruel things like input 
masks, the actual entry can be variable.  Therefore you can have a textbox 
with its Format property set to dd mmm yyyy and then in that textbox you can 
enter 12/5 (current year will be assumed) and then you will see 12 May 2010.

Or have I misunderstood your question?

Regards
Steve


--------------------------------------------------
From: "Jim Lawrence" <accessd at shaw.ca>
Sent: Wednesday, June 16, 2010 5:57 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: [AccessD] Date standardization

> Hi All:
>
> I have been working on a remote site and I have been having problems with
> dates. In this application, I did not have control for its conception and
> date issues keep popping up from time to time.
>
> In all the spots I can find, I have forced the entry of a date standard 
> 'dd
> Mon yyyy'...i.e. 12 May 2010. There are probably 50 date entry points in
> this application and another bunch of date display and report dates that
> have to be handled.
>
> As I do not have complete control over the system, is there a way under
> program control to set the default date entry to dd Mon yyyy? For both FE
> and BE?
>
> MTIA
> Jim