Formatting Text Boxes in Reports

  • Thread starter Thread starter Ann Hornbeck
  • Start date Start date
A

Ann Hornbeck

I am trying to create a text box that contains the
expression ="This Agreement shall expire on "&([Expiration
Date])&"." so that this field will return on my report the
sentance

This Agreement shall expire on July 31, 2026. (or
whatever date my record has in the query.)

I wish the date formatting to be long as I've shown, but
cannot get the text box to return the correct date
format. I've changed the format of the date field in the
underlying table and query to mmmm dd, yyyy but it still
is not returning the format I want.

Have had a similar problem with including currency in a
sentance in an expression in a text box. Seems so simple,
but I just cannot get it to work.

Anyone have any ideas? Thanks,
 
You have to explicitly format the date when it's included in a string.
="This Agreement shall expire on " & Format([Expiration Date],"mmmm d,
yyyy") & "."
 
Back
Top