I feel your pain. I've had to do conditional formatting based on some kind of function, but I'll defer that to one of the MVP's or someone more adept than I.
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, December 16, 2015 3:12 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Continuous form -- row colors
I have a continuous form consisting of these fields: purchase order number, item description, item quantity, item cost, date and other fields. The underlying query is sorted by purchase order number ascending. Each purchase order has a random number of items associated with it. Some purchase order numbers are missing.
I'd like to set the background color to a light grey for every other purchase order for all of the fields in the rows associated with that purchase order. I have looped through a recordset and successfully picked out the rows for which I want a light grey backcolor. I set the FieldName.Backcolor property to the light grey color but I always end up changing the backcolor of all of the rows. How do I restrict the backcolor change to just the selected rows?
Steve
------------------------------------
Posted by: Steve <thaw5@suddenlink.net>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar