[AccessD] Format date in a text box

Jim Lawrence (AccessD) accessd at shaw.ca
Thu Jun 10 09:33:56 CDT 2004


Hi Chester:

Try: monthname(month(date()))

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kaup, Chester
A
Sent: Thursday, June 10, 2004 7:03 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Format date in a text box


I am trying to display the full month name in a text box on a report. I
tried the following but get January1. What should the format statement
look like? Thanks
=Format(Month(Date()),"mmmmm")

Chester Kaup
Information Management Technician
IT-MidContinent/MidContinent Business Unit
CTN 8-687-7415  
Outside 432-687-7414

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced. 



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list