Hi,

Is it possible to display a Date in text box in Month "Year Format"
(Eg, October 02).  on a report.

I currently read a Date from a query into a Textbox in dd/mm/yy (Eg,
25/10/02) but need the date in the above format.

Any Help is appreciated.

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.

Sure,

Try format(YourDateField,"mmmm yy")


John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities

www.noclassroom.com
Live software training
Right over the Internet

Home:  xxx.xxx.xxxx
Cell:  xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498




-----Original Message-----
From: Tim Maher [mailto:tim.maher@s...] 
Sent: Friday, October 25, 2002 2:13 AM
To: Access
Subject: [access] Formatting Date Field In a Report


Hi,

Is it possible to display a Date in text box in Month "Year Format" (Eg,
October 02).  on a report.

I currently read a Date from a query into a Textbox in dd/mm/yy (Eg,
25/10/02) but need the date in the above format.

Any Help is appreciated.

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.