Dates on a form

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
 
V

Van T. Dinh

Set the ControlSource of the TextBox to:

= "Figures for the month of " & Format(Date(), "mmmm")
 
F

fredg

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")
 
V

Van T. Dinh

Sorry. My answer was mistakenly done for current month.

See Fred's answer for last month.
 
Top