formatting date field in access table

  • Thread starter Thread starter Ivy
  • Start date Start date
I

Ivy

How and where in design view do you format a date field
in an Access table as: January 1, 2004? Once this is
done, will the formatting remain when this field is mail
merged into Word? Any help will be greatly appreciated.
Thank you, Ivy
 
Dates are actually stored as 8 byte floating point numbers, where the
integer part represents the date as the number of days relative to 30 Dec,
1899, and the decimal part represents the time as a fraction of a day. In
other words, they aren't stored with any format.

You can set a format of mmmm d, yyyy to get January 1, 2004 (or mmmm dd,
yyyy to get January 01, 2004), but I don't believe that will be propagated
when the field is mail merged.

However, create a query, and put Format([MyDateField], "mmmm d, yyyy") as a
computed field in the query, then use that query rather than the table, and
you should be fine.
 
Back
Top