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

set date to a 6 digit format

P: n/a
I set the input mask for the date field to "00/00/00;0_" but instead of
showing a 6 digit date such as 01/01/06, I receive 01/01/2006 an 8
digit date!

Is there a manner in which I can over ride this?...In the table
containing this date field? Or by way of the textbox control in which
the date is entered on my subform?

Thanks!,

jmarr02s

Nov 15 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
jmarr02s wrote:
I set the input mask for the date field to "00/00/00;0_" but instead
of showing a 6 digit date such as 01/01/06, I receive 01/01/2006 an 8
digit date!

Is there a manner in which I can over ride this?...In the table
containing this date field? Or by way of the textbox control in which
the date is entered on my subform?

Thanks!,

jmarr02s
Dates are always stored exactly the same way. Formatting only controls how
they are displayed and InputMasks only control how they are entered.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Nov 15 '06 #2

P: n/a
jmarr02s wrote:
I set the input mask for the date field to "00/00/00;0_" but instead of
showing a 6 digit date such as 01/01/06, I receive 01/01/2006 an 8
digit date!

Is there a manner in which I can over ride this?...In the table
containing this date field? Or by way of the textbox control in which
the date is entered on my subform?

Thanks!,

jmarr02s
The input mask if for entering the data, not how it's displayed. Set
the format to mm/dd/yy in the property sheet of the form or the table.
Nov 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.