Heh. Funny you should be the one to reply. I'm using a modified version of
your alternate shading routines. I have several fields in my form and I
wanted to be able to group 'like' rows togther (based on one field being
equal).
My two alternatives were some sort of freezing of the panes (in order to
keep the two left-most columns visible as the user scrolls to the right),
which I apparently can't do in continuous form mode, or use some sort of
visual grouping method, such as drawing lines between different sections or
use shading as I have chosen to do thanks to your site.
To give you more detail than you probably care to know: I have several rows
of quotations along with cost detail breakdowns. Each quote belongs to a
Project Number that corresponds to a physical part. Therefore, as a part goes
through changes in its life, each time it is quoted it gets quoted under the
same Project Number. It's our way of keeping the quotes for one part in a
single collection (in the automotive world, a part can change its part number
several times and still be considered the same part - so customer part number
wouldn't work for that).
So my two left-most columns consist of Proj # and Quote #. The data is
sorted by Proj #. Right now, I alternate shading based upon changes in Proj #
(so that all quotes under the same Proj # are shaded the same color). That
way, as the user scrolls to the right, at least they know which rows are for
the same part.
I'm open to alternate ideas - I've thought about using Datasheet view for
the form or using subforms (which again, you can't apparently do in
continuous form mode), but none of those ideas seemed to work for me.
