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
..

"HAH" <(E-Mail Removed)> wrote in message
news:ACDF62E9-2C9E-4981-A3CC-(E-Mail Removed)...
>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?

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.

"John Spencer" wrote:

> 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
> ..
>
> "HAH" <(E-Mail Removed)> wrote in message
> news:ACDF62E9-2C9E-4981-A3CC-(E-Mail Removed)...
> >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?
>
>
>

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

Thanks for the advise.

Hollie Hoffman

"HAH" wrote:

> 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.
>
> "John Spencer" wrote:
>
> > 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
> > ..
> >
> > "HAH" <(E-Mail Removed)> wrote in message
> > news:ACDF62E9-2C9E-4981-A3CC-(E-Mail Removed)...
> > >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?
> >
> >
> >

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?



"John Spencer" wrote:

> 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
> ..
>
> "HAH" <(E-Mail Removed)> wrote in message
> news:ACDF62E9-2C9E-4981-A3CC-(E-Mail Removed)...
> >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?
>
>
>

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.


"efandango" <(E-Mail Removed)> wrote in message
news:55FF7A30-AC47-4BD0-9C63-(E-Mail Removed)...
> 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?
>
>
>
> "John Spencer" wrote:
>
>> 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
>> ..
>>
>> "HAH" <(E-Mail Removed)> wrote in message
>> news:ACDF62E9-2C9E-4981-A3CC-(E-Mail Removed)...
>> >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?
>>
>>
>>

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

On Mar 23, 10:18 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WWWdotlebansdot...@linvalid.com> wrote:
> 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.