Q
Quin
I have the date in my database as mm/dd/yy. I need to change to ddmmyy. How
do I do this? Thanks.
do I do this? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
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
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
S
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
V
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.
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.
Q
Quin
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.
get this format? Where do I find the Controls that you mentioned? I'm still
new to Access. Thanks.
J
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]
Q
Quin
It worked. Thanks!
John Vinson said: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]