date format in concatenated field

[country.cuzn]

I'd like the date format to automatically change for each
month. This is in an Access form and thought it could be
done with Format().

"Sales for December 2003"

Please help

 

[Allen Browne]

Set the Control Source of the text box to something like this:
="Sales for " & Format(Date(), "mmmm yyyy")

 

[Vina]

Add a text box in your form and go to properties and in
the Control Source enter:

="Sales for " & Format(Now(),"mmmm") & Format(Now
(),"yyyy")

Hope this works for you.
Vina