Rogue future date field highlighting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Highlight the field and look up conditional formatting. It is in one of the
menus.
 
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...
 
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...
 
You must log in or register to reply here.

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

Excel High lightng dates in future, today and past 1
Determining the day of the week far into the future. 2
Conditional formating on calculated fields 3
Access Property sheet data missing also syntax 0
If duplicate value apply conditional format 3
Update table with future date calculated in form 5
Access Building a IIF expression in Access 0
Change color on date field in form for re-certification 1

Back
Top