Change MM/DD/YYYY to MM/DD/YY

[petz]

I have a report with a large amount of data and would like to change my date
formats from MM/DD/YYYY to MM/DD/YY to save some space. I've added the input
mask, format and everything listed in previous posts, but I still get the old
format. Is there a way to do this? thanks, petz

 

[KARL DEWEY]

Formats are not stored in Access tables. You need to set the format in the
report.

 

[petz]

Thanks Karl,

I tried this in the field properties:

Name - Expected Date
Control Source - Expected Date
Format - 00/00/00 and it was backfilled with this - 00\/00\/00
Decimal Places - 0
Input Mask - 00/00/00;0;

I still get the mm/dd/yyyy in my output. Did I miss something?
thx, petz

 

[KARL DEWEY]

Format - mm/dd/yy

No mask.

 

[John Spencer]

If it is a date then set the control's format To
mm/dd/yy

Also, I would set the input mask the same way.

Unless Expected Date is a text field then this should work for you.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[John W. Vinson]

I still get the mm/dd/yyyy in my output. Did I miss something?

Is the table field a Date/Time datatype (which will accept various formats) or
a Text field? If it's Text then Access won't recognize it as a date and the
date/time formats won't work (or won't work correctly).