Conditional formatting and Back Style

[Carl Rapson]

I have a report that contains several subreports. I also simulate a
watermark on the report by setting the report's Picture property to an image
file. This all works pretty well, except for one of the subreports. This
subreport uses conditional formatting to bold some of the fields in certain
circumstances. The problem is, when the fields are bolded by the conditional
formatting, a 'white' background is also added to the fields. This causes a
white box to 'block out' a rectangular section of the watermark, right where
the subreport fields lie. This doesn't occur for all of the other
subreports, which are not using conditional formatting. I've set each
field's Back Style property to Transparent, but that doesn't seem to take
effect; the Back Style property seems to be superceded by the conditional
formatting. I can't see any option under Conditional Formatting for making
the field's background transparent. If I bold the subreport fields in the
Detail_Format event (for example), then that field is bolded on ALL records
in the subreport rather than just the current record; that's why I'm using
conditional formatting.

Is there any way to use conditional formatting and still make a field
transparent?

Thanks,

Carl Rapson

 

[Marshall Barton]

I have a report that contains several subreports. I also simulate a
watermark on the report by setting the report's Picture property to an image
file. This all works pretty well, except for one of the subreports. This
subreport uses conditional formatting to bold some of the fields in certain
circumstances. The problem is, when the fields are bolded by the conditional
formatting, a 'white' background is also added to the fields. This causes a
white box to 'block out' a rectangular section of the watermark, right where
the subreport fields lie. This doesn't occur for all of the other
subreports, which are not using conditional formatting. I've set each
field's Back Style property to Transparent, but that doesn't seem to take
effect; the Back Style property seems to be superceded by the conditional
formatting. I can't see any option under Conditional Formatting for making
the field's background transparent. If I bold the subreport fields in the
Detail_Format event (for example), then that field is bolded on ALL records
in the subreport rather than just the current record; that's why I'm using
conditional formatting.

Is there any way to use conditional formatting and still make a field
transparent?

The only issue I've seen with this is that setting a
conditional format also sets the control's back style to
normal. Just resetting the property back to transparent
seems to take care of it (until you fiddle with CF again).

 

[Carl Rapson]

Thanks for replying, Marshall. Unfortunately, for me it doesn't seem to
work. I remember noticing that the CF changed the control's Back Style to
Normal, but I when set it back to Transparent I still get the same effect.
The control's Back Style is currently Transparent, but I still have the
'white box' occluding my watermark. I appreciate any other ideas, and I'll
keep working with it.

Carl Rapson

 

[Marshall Barton]

Sorry Carl, I can't get it to do that even when I set the CF
back color. As soon as I reset the BackStyle to transparent
it works ok (A2002).

Are you sure you don't have a label, rectangle or another
text box behind the one with the problem?

 

[Carl Rapson]

I'm also using Access 2002. I've checked, and I can't see any other fields
behind the ones having the problem. I've compared the subreport to the other
subreports in my main report, and I can't see any differences in the
properties (except for positioning). Thanks for following through with this,
your comments make me think that there is indeed something wrong somewhere,
if I can just find it. I will keep looking.

Carl Rapson

 

[Marshall Barton]

Good luck on figuring it out.

Still scratching my head over this one and would appreciate
a followup if you get any closer to an answer.

 

[Carl Rapson]

Thanks, will do.

Carl Rapson