ACCESS FEED: Re: [MS_AccessPros] Continuous form -- row colors

Kamis, 17 Desember 2015

Re: [MS_AccessPros] Continuous form -- row colors

Steve-

There have been several discussions on this forum over the years about ways to do this - the most recent was in the last couple of months, but I can't find the thread. I did spot a sample database in 1_Samples folder on the forum's website: cont_form_BKcolor.zip that may have a good example.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Dec 16, 2015, at 11:11 PM, Steve thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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