Dates on a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Box 666 - 30 Apr 2004 01:50 GMT

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

Reply to this Message

Van T. Dinh - 30 Apr 2004 03:09 GMT

Set the ControlSource of the TextBox to:

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

Signature

HTH
Van T. Dinh
MVP (Access)

> I want to have an unbound text box that will always display last months date
> in the form of
[quoted text clipped - 7 lines]
> with thanks
> Bob

Reply to this Message

Van T. Dinh - 30 Apr 2004 03:44 GMT

Sorry. My answer was mistakenly done for current month.

See Fred's answer for last month.

Signature

HTH
Van T. Dinh
MVP (Access)

> Set the ControlSource of the TextBox to:
>
> = "Figures for the month of " & Format(Date(), "mmmm")

Reply to this Message

fredg - 30 Apr 2004 03:15 GMT

> I want to have an unbound text box that will always display last months date
> in the form of
[quoted text clipped - 7 lines]
> with thanks
> Bob

="Figures for the month of " & Format(DateAdd("m",-1,Date()),"mmmm")

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message