Hello -- I wonder if someone might be able to help me. My problem is I cannot get a mass mailing Report for printing to show a Long Date rather it shows only a Short Date on the Report/letter. I have set the control source for the Date Time field in the Report as =Date() with a Long Date format. See 1:46 in Expert 6 02. However, it remains a Short Date. In addition, alternatively, I have tried setting the Report DateTime field control source to look at my open Letter Form using =Forms!LetterF!DateTime (with brackets). This does not work either despite the fact that the DateTime field on LetterF is a Long Date. Do anyone have any suggestions in order to show a Long Date on my printed letter? Thanks very much.
Adam Schwanz
@Reply 2 years ago
Have you tried changing the control source and coding the format?
=Format([FieldName],"Long Date") or sometimes I've even had to do
=Format(CStr([FieldName]),"Long Date")
Chistine EverettOP
@Reply 2 years ago
Thank you so much! =Format([Forms]![LetterF]![DateTime], "Long Date") worked for me. I now have finally a long date in my letters!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 6.
