conditional formatting - days & hours

  • Thread starter Thread starter clueless
  • Start date Start date
C

clueless

I have a field in my report called [Available]. I assume this is probably
very simple but everything I have tried doesn't work and my brain now
"hurts". The field shows on my report as, for example, 3 days 2 hours. I
want the field to be highlighted if it is greater than 3 days exactly (72
hours). Any help would be truly appreciated. Thank you in advance.
 
"How" depends on "what" -- what data are you working with behind this
report?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I'm assuming that this [Available] field is some sort of computed value that
is formatted as Days and hours, which would not be easy to evaluate in
conditional formatting. However, if it is a computed value, is must have a
numeric hours field that it uses to make the computation. If so, include
that field, (I'll call it [Available_hours]) in your reports recordsource.
Then, select the [Available] textbox and click on Conditional Formatting.

In the conditional formatting, select the "Expression Is" option in the
combo box, then put: [Available_Hours] > 72
in the textbox to the right of "Expression Is", then set the background
color.
 
Hey Dale & Jeff,
Thanks so much for your help. Sorry I did not elaborate better but my brain
was really hurting and I was ready to toss the computer into the wall (yes,
one of those days). Dale - your solution works perfectly (it was a
calculated field)! Thank you both for quickly responding. You guys have
saved the life of my computer many times and it is always appreciated.
Thank you!
--
clueless


Dale Fye said:
I'm assuming that this [Available] field is some sort of computed value that
is formatted as Days and hours, which would not be easy to evaluate in
conditional formatting. However, if it is a computed value, is must have a
numeric hours field that it uses to make the computation. If so, include
that field, (I'll call it [Available_hours]) in your reports recordsource.
Then, select the [Available] textbox and click on Conditional Formatting.

In the conditional formatting, select the "Expression Is" option in the
combo box, then put: [Available_Hours] > 72
in the textbox to the right of "Expression Is", then set the background
color.


clueless said:
I have a field in my report called [Available]. I assume this is probably
very simple but everything I have tried doesn't work and my brain now
"hurts". The field shows on my report as, for example, 3 days 2 hours. I
want the field to be highlighted if it is greater than 3 days exactly (72
hours). Any help would be truly appreciated. Thank you in advance.
Click to expand...
Click to expand...
 
Back
Top