Conditional formatting

[Sue]

I know there are many subjects on this, but can't find the answer.
I have several text boxes with number values in it. The names of these text
boxes have the current year in the name.
Example of all the text boxes on my form:
2004 grants
2005 grants
2006 grants
ETC.....
I want to format the text box values in red if the current year is simialir.
Example i want "2005 Grants" to be highlighted for this year. Next year i
want the 2006 Grants box to be highlighed on the form. ETC
THANKS

 

[Rick B]

I would think you would use something like...

left([yourfieldname],4) = year(date())

 

[Sue]

Thank you. One more quesiton. DO you put this in he before update event or?

I would think you would use something like...

left([yourfieldname],4) = year(date())

--
Rick B

I know there are many subjects on this, but can't find the answer.
I have several text boxes with number values in it. The names of these text
boxes have the current year in the name.
Example of all the text boxes on my form:
2004 grants
2005 grants
2006 grants
ETC.....
I want to format the text box values in red if the current year is simialir.
Example i want "2005 Grants" to be highlighted for this year. Next year i
want the 2006 Grants box to be highlighed on the form. ETC
THANKS

 

[Rick B]

No, you put it in the "conditional formatting" dialog box. No coding
needed.


--
Rick B

Thank you. One more quesiton. DO you put this in he before update event or?

I would think you would use something like...

left([yourfieldname],4) = year(date())

--
Rick B

I know there are many subjects on this, but can't find the answer.
I have several text boxes with number values in it. The names of

these
text

boxes have the current year in the name.
Example of all the text boxes on my form:
2004 grants
2005 grants
2006 grants
ETC.....
I want to format the text box values in red if the current year is simialir.
Example i want "2005 Grants" to be highlighted for this year. Next year i
want the 2006 Grants box to be highlighed on the form. ETC
THANKS

 

[Sue]

thanks but that didn't work in the expression

No, you put it in the "conditional formatting" dialog box. No coding
needed.


--
Rick B

Thank you. One more quesiton. DO you put this in he before update event or?

I would think you would use something like...

left([yourfieldname],4) = year(date())

--
Rick B



I know there are many subjects on this, but can't find the answer.
I have several text boxes with number values in it. The names of these
text
boxes have the current year in the name.
Example of all the text boxes on my form:
2004 grants
2005 grants
2006 grants
ETC.....
I want to format the text box values in red if the current year is
simialir.
Example i want "2005 Grants" to be highlighted for this year. Next year i
want the 2006 Grants box to be highlighed on the form. ETC
THANKS