set default date format in 2003

[NJS]

Good day All.
does anyone know if there is an Access database default date format
property, or any way of setting the default date format for a specific
database in 2003?
OR
Is windows regional settings the only place to do this?
thanks

 

[NJS]

SORRY, default MEDIUM date format

 

[Arvin Meyer [MVP]]

You can create a custom date format function and call it in the control's
after update event. It is easier however to do it in the regional settings.
If it is simply a matter of 2 or 4 digit years, you can set that per
database or for all databases in

Tools >>> Options >>> General tab

 

[NJS]

Thanks Arvin.
Unfortunately there are hundreds of date fields, so I have to do it at
application or O/S level. I have set the short and long date regional
settings, but because all the date fields are set to medium, the format
changes. If I create a new form-field, and leave the format to
nothing/default the correct order show. 'Medcium' seems to switch month and
day?

 

[Tony Toews [MVP]]

Unfortunately there are hundreds of date fields, so I have to do it at
application or O/S level.

You could write some code that goes though all the forms and updates
the various date/time control fields Format settings.

The problem would be identifying which controls are date/time fields.
Assuming that if you have non unique field names that at least you
were consistent with field usage based on name.

Create a table listing all the fields in the tables in your app which
are date/time type. Then go through all the forms and the controls on
the forms using the forms collection and the controls collection.
Update the format property for bound fields which have the same name
as in that previously mentioned table.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Arvin Meyer [MVP]]

Build some code to loop through the forms collection, then nest a loop
through the controls collection, looking for controls set to the medium date
format. When you find them, change the format to one that you want. While
not exactly what you want, you can find some similar looping code in my
sample databases at:

http://www.datastrat.com/Download/FixNames.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[NJS]

Thanks Guys,
so the answer is 'there is no way to set medium-date default format in
Access or Windows'?
Why do you think the dd/mm switches to mmm/dd when changing from short
(default) to medium?

 

[Arvin Meyer [MVP]]

Because that's the design of the format. You can as previously mentioned
create your own format. And you can loop through the forms and controls
collections and set that format using code similar to what I posted below.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com