Conditional Formatting of text effecting formatting of background

[Guest]

I have a report that shades the background of alternate rows of data. I
tried to set a conditional format to change the text color when one of the
fields is <2. The alternate row background shading vanished for that field,
regardless of what the conditional format causes the text color to do. Is
there any way to fix this?

 

[John Spencer]

No guarantee, but after setting the conditional formatting up, try the
following
-- Select the control you have just set up with conditional formatting
-- Select Back Style and set that to transparent.

I tested it with Access 2000 and that seemed to resolve the problem for me.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Well, that fixed the background color, but now there is a slight jog in the
row where that space taken up by that control shifts slightly (less than a
grid space) upwards in relation to the rest of the row.

 

[Guest]

Never mind, I lowered the upper boundry of the control & that fixed it, so
everything's now copasetic.

Thanks for the advise.

Hollie Hoffman

 

[efandango]

amazingly (and annoyingly) this bug still occurs in Access 2007! c'mon
Microsoft, fix this irritiating problem. Meanwhile, I have tried John's
suggestion; but for me it doesn't work. Has anyone got any other suggestions?

 

[Stephen Lebans]

Why even bother with CF for a report. It's simple to write a few lines of
code in the Detail section Format event to accomplish your goals.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Keith]

What event would you put the code in?

I am using a form with a datasheet view with detail in the header.

When I put conditional format code in the OnPaint event, it
continually repaints the screen and never stops.
Keith