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
 
Ad

Advertisements

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

Top