Change System date format

G

Guest

Hi,

I'm using MS Access XP.
How can I change the system date format (short/Long) (mm/dd/yyyy ->
DD/MMM/YYYY) FROM VBA?
I know how to change to system (Date = #1/1/2005#).

Thanks in advance
jouj
 
D

Douglas J. Steele

Why?

The format comes from Regional Settings, so if you're trying to change it
permanently, you're messing with the user's personally chosen settings,
which is strongly discouraged.

If you're strictly trying to control how it appears in a control, set the
format for that control.

If there's some other reason, post back more details, and someone should be
able to suggest a work-around.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing a date entry format of dd/mm/yyyy 1
Combo box date format changes when item selected from list 4
Medium Date format and calendar in Access 2007 1
Form Control Calendar date will not change its format 1
Date field not stay in same format 1
Not Returning Correct Answer 5
Text Box Date Format 2
convert date 1

Top