Dates on a form

  • Thread starter Thread starter Box 666
  • Start date Start date
B

Box 666

I want to have an unbound text box that will always display last months date
in the form of

"figures for the month of " March
or
"figures as at "31st March

where March is always the previous month to the current date

with thanks
Bob
 
Set the ControlSource of the TextBox to:

= "Figures for the month of " & Format(Date(), "mmmm")
 
I want to have an unbound text box that will always display last months date
in the form of

"figures for the month of " March
or
"figures as at "31st March

where March is always the previous month to the current date

with thanks
Bob
Click to expand...

="Figures for the month of " & Format(DateAdd("m",-1,Date()),"mmmm")
 
Sorry. My answer was mistakenly done for current month.

See Fred's answer for last month.
 
Back
Top