If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditional formatting - days & hours
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. -- clueless |
#2
|
|||
|
|||
conditional formatting - days & hours
"How" depends on "what" -- what data are you working with behind this
report? Regards Jeff Boyce Microsoft Office/Access MVP "clueless" wrote in message ... 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. -- clueless |
#3
|
|||
|
|||
conditional formatting - days & hours
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" wrote in message ... 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. -- clueless |
#4
|
|||
|
|||
conditional formatting - days & hours
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" wrote: 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" wrote in message ... 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. -- clueless |
Thread Tools | |
Display Modes | |
|
|