Dates not holding format when included in a text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When building a report to fill in form letters directly in Access97, I have a custom date format that will not 'stick' to the date field when I include it in a text box. As an example, I set a data source for a text box using the expression builder, "Your meeting for "&[Date]&" has been postponed. Please reschedule.
The custom format I set up was mmmm dd","yyyy which gives a "March 20, 2004" date field just fine in the table, in the query, and in the [Date] control on the report. But when I enclose it in the text box expression, all I get is 3/20/2004
Has anyone out there found a cure for this problem? For that matter, has anyone else encountered the problem
Thanks.
 
When building a report to fill in form letters directly in Access97,
I have a custom date format that will not 'stick' to the date field
when I include it in a text box. As an example, I set a data source
for a text box using the expression builder, "Your meeting for
"&[Date]&" has been postponed. Please reschedule." The custom
format I set up was mmmm dd","yyyy which gives a "March 20, 2004"
date field just fine in the table, in the query, and in the [Date]
control on the report. But when I enclose it in the text box
expression, all I get is 3/20/2004! Has anyone out there found a
cure for this problem? For that matter, has anyone else encountered
the problem? Thanks.
Click to expand...

When you concatenate fields you lose individual formatting.
Use:

="Your meeting for " & Format([Date],"mmmm dd yyyy") & " has been
postponed. Please reschedule."

note:
If you really have a field named "Date" you would be well advised to
change it to something else, i.e. AppointDate, dteDate, OrderDate,
etc.,
Date is a reserved word in Access and should not be used as a field
name.
See the appropriate Microsoft KnowledgeBase article for your version
of Access.
109312 'Reserved Words in Microsoft Access'
209187 'Acc2000: 'Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
 
Back
Top