Thanks for the help guys!
Realistically, I would be happy with two shades of gray just to
distinguish between different dates. Like, the most recent date would
be white, the next set of entries with a different date would be gray,
the next set white, etc. Sort of like alternating rows, only that I
want the color to change when it hits a different date. So some kind
of code that would look at a record's date, evaluate if its the same
or different, if it's different, set the row to the alternate color,
go to the next row, evaluate, change if, etc...
Could I do this with the True/False thing you suggested Phil? or is
there another way?
On Jun 18, 8:04 am, "Phil Stanton" <p...@myfamilyname.co.ukwrote:
Two thoughts
1) Use a contionuous form. Can be made to look like a datasheet but allows
formatting
2) As there are presumably an unknown number of dates, you are going to need
an unknown number of colours, so that option is not on.
3) Try experimenting with a line whose visibility is changed by setting it
to False for the same date and True for a different date
Phil
"RussCRM" <srusskin...@gmail.comwrote in message
news:f7**********************************@f63g2000 hsf.googlegroups.com...
I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.
Any ideas?