Thread: Format Date (Access 2003)
2008-05-25, 21:03 #1
- Join Date
- Sep 2002
- Edmonton, Alberta
- Thanked 0 Times in 0 Posts
Format Date (Access 2003)
Could someone help me with the way to format the date in an unbound field. The field is: ="Summary for: " & [CN_MAR_DATE] The date displays as ex: 01/01/08 I want it to display as 01 Jan 08 (medium Date) I have set the format in the tables & queries but it still displays as above.
Thanks in Advance.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2008-05-25, 21:24 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: Format Date (Access 2003)
Here are two different ways of doing this:
1) Set the Control Source of the text box to
="Summary for: " & Format([CN_MAR_DATE], "Medium Date")
="Summary for: " & Format([CN_MAR_DATE], "dd mmm yy")
2) Set the Control Source of the text box to CN_MAR_DATE and set the Format property to
"Summary for: "dd mmm yy