formatting date field in access table

[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

 

[Douglas J. Steele]

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.