[AccessD] Format date in a text box

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.