Date format when passing data to an Email

[jdp103]

I have a button on a form that creates an email and inserts fields from my database. I have a field that is set to Long Date format type, but when it populates the email, it shows as a Short Date format type. Is there anyway to retain the Long Date format?

 

[Pat Hartman]

A format defined in a table only controls how the data is displayed when you open the table in datasheet view. In newer versions of Access, some field table properties are copied to forms and reports when they are originally made. I don't believe that changes are propagated. In A2003, it asks you if you want to propagate the change. If you want to control the data format on export, you need to do it with the Format() function in a query and export the query rather than the table.