Rogue future date field highlighting

H

Hammond-Wandsworth

Within the query my form is based on I have a date field called Date Adopted.
I have then added a number of expressions that calculate 14, 28, 43 and 56
days from the date in Date Added. An example expression is: Expr1: [Date
Adopted]+14. On my form I have added new text boxes for the expressions in my
query. My problem is that if the expression fields match today's or a future
date the field is highlighted green with red writing. I don't want this to
happen - I just want it to be normal and unhighlighted (black on white). How
can I stop it from highlighting future dates? Anyone got any ideas? I'd very
much appreciate it.
 
S

scubadiver

Highlight the field and look up conditional formatting. It is in one of the
menus.
 
H

Hammond-Wandsworth

Thank you scubadiver, much appreciated.

scubadiver said:
Highlight the field and look up conditional formatting. It is in one of the
menus.

--
www.ae911truth.org



Hammond-Wandsworth said:
Within the query my form is based on I have a date field called Date Adopted.
I have then added a number of expressions that calculate 14, 28, 43 and 56
days from the date in Date Added. An example expression is: Expr1: [Date
Adopted]+14. On my form I have added new text boxes for the expressions in my
query. My problem is that if the expression fields match today's or a future
date the field is highlighted green with red writing. I don't want this to
happen - I just want it to be normal and unhighlighted (black on white). How
can I stop it from highlighting future dates? Anyone got any ideas? I'd very
much appreciate it.
Click to expand...
Click to expand...
 
S

scubadiver

ok. I wasn't sure whether that was the answer.



Hammond-Wandsworth said:
Thank you scubadiver, much appreciated.

scubadiver said:
Highlight the field and look up conditional formatting. It is in one of the
menus.

--
www.ae911truth.org



Hammond-Wandsworth said:
Within the query my form is based on I have a date field called Date Adopted.
I have then added a number of expressions that calculate 14, 28, 43 and 56
days from the date in Date Added. An example expression is: Expr1: [Date
Adopted]+14. On my form I have added new text boxes for the expressions in my
query. My problem is that if the expression fields match today's or a future
date the field is highlighted green with red writing. I don't want this to
happen - I just want it to be normal and unhighlighted (black on white). How
can I stop it from highlighting future dates? Anyone got any ideas? I'd very
much appreciate it.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Cobditional Formatting Rows based on dates in action plan. 0
Determining the day of the week far into the future. 2
calculate a future date 2
Conditional formating on calculated fields 3
dafault value for date not working with Date() but Now() is workin 5
Syntax error in date in query expression issue 4
Date Conversion Solar date to Gregorian 2

Top