date format in concatenated field

  • Thread starter Thread starter country.cuzn
  • Start date Start date
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
 
Set the Control Source of the text box to something like this:
="Sales for " & Format(Date(), "mmmm yyyy")
 
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
 
Back
Top