Hi,
Is it possible to change the color of a row in a form in datasheet view when it loads. For example, if the [storename]= Auntie Anne's the row color would be pink.
Thanks!
Leesha
Changing Row Color is Datasheet view
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Changing Row Color is Datasheet view
Hi Leesha,Leesha wrote:Hi,
Is it possible to change the color of a row in a form in datasheet view when it loads. For example, if the [storename]= Auntie Anne's the row color would be pink.
Thanks!
Leesha
If you use conditional formatting, it seems like you will need to set up each field in the datasheet form to have the same conditional statement to simulate shading the entire row.. It looks like you don't have to option to format an entire row via CF.
I did find a web page from Lebans that provides programatic solutions, but I did not scrutinise the code to determine how it works and if it might resolve your query...
See the solution here...
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Changing Row Color is Datasheet view
Hi Rudi!! This worked great. Thanks!