[AccessD] Format date in a text box

Stuart McLachlan stuart at lexacorp.com.pg
Thu Jun 10 17:27:22 CDT 2004


On 10 Jun 2004 at 9:02, Kaup, Chester A wrote:

> 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")
> 
One too many "m", the first four gets you the "January", the fifth one gets you 
the "1"

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.






More information about the AccessD mailing list