set date to a 6 digit format

[jmarr02s]

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

[Rick Brandt]

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

[salad]

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.