6 digit Date Format

[Ian]

I have a report that shows a date along with many other fields, I am trying
to keep this date field as small as possible to make room for other fields
so I want it to be a 6 digit date.

My problem is that Windows default Short Date uses 8 digits not 6 so when I
distribute my DB the user has to change the standard regional settings, what
I want to do is format the date to be 6 digits.

I have tried setting the fields Format to DD\MM\YY instead of Shot Date,
this works fine but forces the displayed date to show the Day before the
Month, some users might want the month to be shown first. My question is,
how can I format the text box to display a 6 digit date while retaining the
regional settings of Month or Day first?

Regards

[Douglas J. Steele]

"Ian" <ia********@ntlworld.com> wrote in message
news:xy******************@newsfe1-win.ntli.net...

I have tried setting the fields Format to DD\MM\YY instead of Shot Date,
this works fine but forces the displayed date to show the Day before the
Month, some users might want the month to be shown first. My question is,
how can I format the text box to display a 6 digit date while retaining
the regional settings of Month or Day first?

AFAIK, you can't. If this is essential to your application, you could write
a function that determined the user's Short Date format (hint: use something
like DateSerial(2003, 2, 1) and parse it to see where the 2 and 1 occur) and
explicitly set the Format property of the textbox depending on what you
return from that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)