|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 30th, 2004, 01:50 AM
|
|||
|
|||
Dates on a form
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 
|
|
#2
April 30th, 2004, 03:09 AM
|
|||
|
|||
|
Dates on a form
Set the ControlSource of the TextBox to:
= "Figures for the month of " & Format(Date(), "mmmm") -- HTH Van T. Dinh MVP (Access) "Box 666" wrote in message ... 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
|
|
#3
April 30th, 2004, 03:15 AM
|
|||
|
|||
|
Dates on a form
On Fri, 30 Apr 2004 00:50:39 GMT, Box 666 wrote:
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 ="Figures for the month of " & Format(DateAdd("m",-1,Date()),"mmmm") -- Fred Please only reply to this newsgroup. I do not reply to personal email.
|
|
#4
April 30th, 2004, 03:44 AM
|
|||
|
|||
|
Dates on a form
Sorry. My answer was mistakenly done for current month.
See Fred's answer for last month. -- HTH Van T. Dinh MVP (Access) "Van T. Dinh" wrote in message ... Set the ControlSource of the TextBox to: = "Figures for the month of " & Format(Date(), "mmmm") -- HTH Van T. Dinh MVP (Access)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
