Pls Hlp w/conditional formatting dates in form

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

Guest

I need help with formatting a couple of dates. I had posted before and it is
not working and I think maybe I did not explain right. I need any help
anybody can give me pls. I have two dates in a subform. I want date2 to
look at date1 and count 7 working days. This is fine I have this working.
However, I want date 2 to check if it is over due by Date(). If it is over
the 7 working days than I want date 2 to be bolded and red. Please can this
be done. Do I need to add another column? I rather not - I just need date 2
column dates to be bolded if needed. Can this be done in conditional
formatting or query? I do not write code yet. Thank you in advance for any
help.
 
Assuming that the second date is calculated in a query by adding 7 days to
the first datefield, uou simply set the second date to:

Field Value Is
less than or equal to
Date()

Then click on Bold and Red and save the form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top