Change System date format

J

jouj

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.
 
Top