By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

6 digit Date Format

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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!)

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.