Conditional Formatting of text effecting formatting of background

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

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?
 
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
..
 
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.
 
Never mind, I lowered the upper boundry of the control & that fixed it, so
everything's now copasetic.

Thanks for the advise.

Hollie Hoffman
 
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?
 
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.
 
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
 
Back
Top