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


P

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
 
Ad

Advertisements

K

KARL DEWEY

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

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
 
J

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
 
Ad

Advertisements

J

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).
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top