DateTime - Microsoft Access Expert 6 - Computer Learning Zone


	Back to Access Expert 6 Comments List

Upload Images Link Email

DateTime

Chistine Everett

12 months ago

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 12 months 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 Everett OP 12 months ago
Thank you so much! =Format([Forms]![LetterF]![DateTime], "Long Date") worked for me. I now have finally a long date in my letters!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 6.