|
| 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
January 17th, 2008, 04:12 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Conditional Format Dates
How do I conditionally format dates that are more than one year old?
-- -Andy 
|
|
#2
January 17th, 2008, 05:22 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Conditional Format Dates
On Thu, 17 Jan 2008 08:12:06 -0800, Andy12 wrote:
How do I conditionally format dates that are more than one year old? In form design view, select the date control. Click on Format + Conditional Formatting. Set Condition1 to Expression Is In the next dialog box, write: [ControlName] DateAdd("yyyy",-1,Date()) Change [ControlName] to whatever the actual name of your control is. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#3
January 17th, 2008, 05:29 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Conditional Format Dates
On Thu, 17 Jan 2008 08:12:06 -0800, Andy12 wrote:
How do I conditionally format dates that are more than one year old? Use a crieterion in the conditional format dialog of: DateAdd("yyyy", -1, Date()) John W. Vinson [MVP]
|
|
#4
January 17th, 2008, 05:30 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Conditional Format Dates
Andy,
FieldValue Less Than DateAdd("yyyy",-1,Date()) -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Andy12" wrote in message ... How do I conditionally format dates that are more than one year old? -- -Andy
|
|
#5
February 9th, 2010, 05:28 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Conditional Format Dates
NOTE: Do not change [ControlName] to the actual name of your control, rather,
change ControlName to the actual name of your control. In other words, do not drop the brackets! "fredg" wrote: On Thu, 17 Jan 2008 08:12:06 -0800, Andy12 wrote: How do I conditionally format dates that are more than one year old? In form design view, select the date control. Click on Format + Conditional Formatting. Set Condition1 to Expression Is In the next dialog box, write: [ControlName] DateAdd("yyyy",-1,Date()) Change [ControlName] to whatever the actual name of your control is. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
