date format change

[Guest]

I have the date in my database as mm/dd/yy. I need to change to ddmmyy. How
do I do this? Thanks.

 

[Nick]

Go to your control panel, Regional Settings, select date
and then set the Short Date Style. Apply and then OK
This should fix your problem. If not try closing the
database, then re-open it, the date format should now be
as you require if you have set the formate in the table
design as short date.

Hope this helps

Nick

 

[silviu]

Go to your control panel, Regional Settings, select date
and then set the Short Date Style. Apply and then OK
This should fix your problem. If not try closing the
database, then re-open it, the date format should now be
as you require if you have set the formate in the table
design as short date.

Hope this helps

Nick

 

[Van T. Dinh]

Note that changing Date format in Regional Settings will also change the
date format in other applications that use the Regional Settings. Use this
with caution.

I would recommend changing the Format Property of the Fields or Controls
rather than changing the Regional Settings.

 

[Guest]

My Format Property in the Fields does not give the option ddmmyy. How do I
get this format? Where do I find the Controls that you mentioned? I'm still
new to Access. Thanks.

 

[John Vinson]

My Format Property in the Fields does not give the option ddmmyy. How do I
get this format?

It's not in the dropdown box of predefined formats - but you can
simply type the letters

ddmmyy

into the Format property. See the online help for Format, and drill
down to custom date formats for lots more options.

Where do I find the Controls that you mentioned? I'm still
new to Access. Thanks.

If you're using table datasheets to do data entry - DON'T. They're
*very* limited in their capability!

When you create a Form based on your table, you'll be putting the data
into "controls" - textboxes, combo boxes, other types of controls - on
the form.

John W. Vinson[MVP]

 

[Guest]

It worked. Thanks!

It's not in the dropdown box of predefined formats - but you can
simply type the letters

ddmmyy

into the Format property. See the online help for Format, and drill
down to custom date formats for lots more options.


If you're using table datasheets to do data entry - DON'T. They're
*very* limited in their capability!

When you create a Form based on your table, you'll be putting the data
into "controls" - textboxes, combo boxes, other types of controls - on
the form.

John W. Vinson[MVP]