 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008Conditional Formatting of text effecting formatting of background
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.  SignatureJohn Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . >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. > No guarantee, but after setting the conditional formatting up, try the > following [quoted text clipped - 8 lines] > > 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 > 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 [quoted text clipped - 12 lines] > > > 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? > No guarantee, but after setting the conditional formatting up, try the > following [quoted text clipped - 8 lines] > > 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. SignatureHTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. > amazingly (and annoyingly) this bug still occurs in Access 2007! c'mon > Microsoft, fix this irritiating problem. Meanwhile, I have tried John's [quoted text clipped - 16 lines] >> > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.