Conditional Format

[tigadr]

I am currently using Access 2007. I have a report to create that has the
detail section back color change according to the shift that submitted the
work order. I have tried to use the conditional formatting feature but that
does not seem to work in any fashion. I know very little Visual Basic just
enough to know that I need to know a lot more. How would I go about this? I
feel very stupid with this problem I have been working with Access for a
while now and thought I was fairly familiar with it. Guess not.

 

[Marshall Barton]

I am currently using Access 2007. I have a report to create that has the
detail section back color change according to the shift that submitted the
work order. I have tried to use the conditional formatting feature but that
does not seem to work in any fashion.

I don't use A2007 enough to know if things are different
from earlier versions, but I suspect they're the same. You
can not use CF for a section, it only applies to text and
combo boxes. This is not a big deal because you can add a
text box, size it to cover the entire section, set up CF on
the text box and then use Send To Back on the Format menu.

When you do this kind of thing, be sure to use CF's
Expression Is option with an expression something like:
[shiftfield] = 1
where the [ ] around field/control names are required.

 

[Claire]

Have you checked the properties of the alternate back color and the back
color for the detail? I had some frustrating time with conditional
formatting until I switched the alternate back color to 'no color' and the
back color to 'automatic'. For each field the back style is listed as
'normal', which if I remember correctly, is what allowed things to actually
change.

 

[tigadr]

Thank you! The text box worked great. I was able to do what I needed to do
and it looks very sharp. Now you can tell at a glance where each item came
from. Thank you again for your help.

I am currently using Access 2007. I have a report to create that has the
detail section back color change according to the shift that submitted the
work order. I have tried to use the conditional formatting feature but that
does not seem to work in any fashion.

I don't use A2007 enough to know if things are different
from earlier versions, but I suspect they're the same. You
can not use CF for a section, it only applies to text and
combo boxes. This is not a big deal because you can add a
text box, size it to cover the entire section, set up CF on
the text box and then use Send To Back on the Format menu.

When you do this kind of thing, be sure to use CF's
Expression Is option with an expression something like:
[shiftfield] = 1
where the [ ] around field/control names are required.