Formatting a date different from the date options available

  • Thread starter Thread starter Janet B
  • Start date Start date
J

Janet B

I am using ACCESS 2007 and would like to format the date as ex: 2009-Nov-19
in a table. It would also be nice if this cell would automatically format
the date to the above format even if the person entering the date typed in
7/9/1975. Could anyone help me do this, or can it even be done?
Thanks, Janet B
 
Janet B said:
I am using ACCESS 2007 and would like to format the date as ex: 2009-Nov-19
in a table. It would also be nice if this cell would automatically format
the date to the above format even if the person entering the date typed in
7/9/1975.
Click to expand...


As long as the table field is data type Date/Time, you can
do that in a table field, query field or form/report text
box by setting its Format property to a custom format:

yyyy-mmm-d

Because users should never see the sheet view of a table,
the only place you should need to do that is on a text box
in a form or report.
 
Back
Top