date format in concatenated field

C

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
 
A

Allen Browne

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

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
 
Top