469,299 Members | 2,035 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

How to preserve alternate row shading in datasheet view with conditional formating?

214 100+
I have a datasheet with alternate row shading and conditional formatting. Unfortunately when the conditional formatting returns true, I lose the alternate row shading for that control.

Has anyone else run into this problem? Does anyone know a fix?
Feb 16 '11 #1
7 5877
32,173 Expert Mod 16PB
What's a datasheet? I'm aware of no such object.

As for using CF with alternate row shading, I can only think that if you are intending to use the CF to set the background, then clearly you are overwriting any alternate row shading set. If the alternate row shading is important then I suggest you forego that option within the CF and set the background to transparent.
Feb 16 '11 #2
214 100+
Sorry I was unclear in my explanation. I have a form which is opened in datasheet view, and defaults to alternate row shading. All good so far. However, I need to apply conditional formatting to the text only (i.e. change color and bold). The conditional formatting works fine, but it also sets the background to white. This happens whether or not I set the background to transparent. See attached file for visual example.

** Edit **

Attached Images
File Type: jpg Datasheet Example.jpg (33.9 KB, 1731 views)
Feb 16 '11 #3
904 Expert 512MB
It is because I think the conditional also sets a fill colour. I will look into it some more and see if I can get it to work.

Feb 17 '11 #4
904 Expert 512MB
I couldn't get it to work in Datasheet view but you will have better luck in continuous form view.

If you really need to stick with the datasheet view then Stephen Lebans has a long convaluted way of changing alternate rows for pre AC2007 versions. With some modifications I think you could get it to work just for the conditions you want and not for alternating rows. Here is the link http://www.lebans.com/conditionalformatting.htm

Feb 17 '11 #5
32,173 Expert Mod 16PB
I tried to look into this for you, but couldn't find any reference to Alternate Row Shading. Is this possibly a version specific feature? Possibly introduced after Access 2003 (which is the version I'm using)?
Feb 17 '11 #6
Stewart Ross
2,545 Expert Mod 2GB
@NeoPa - the built-in alternate row shading was introduced in A2007 as you thought.

Feb 17 '11 #7
32,173 Expert Mod 16PB
Thanks Stewart.

BTW I fired off a reminder to Mary re your account name.
Feb 17 '11 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Dimitri Furman | last post: by
2 posts views Thread by Von Bailey | last post: by
2 posts views Thread by Filips Benoit | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.