REQ: Formatting rows in a subform

[fecket]

I have a subform which is a continous form and displays the content of
a table, with a subjext number, then a line of text, then a score. I
have used an option group to update the score as 0,2,4,6,8,10

When entering the data it is a bit difficult to keep track of where
you are, as you are transferring data from hard copy.

Is there a way to allocate a background colour to individual rows of
the subform to give an overall colour for each grouping. The question
subject numbers are from 200 - 300, 300 - 400 etc so a banded colour
scheme would help you keep track.

I have seen a routine for alternate colouring od lines, but I would
like to do it as a group and allocate a diferent colour to each.

Anyone an ideas ??

fecket

[Stephen Lebans]

Your idea could be implemented via Conditional Formatting but with a
restriction of a total of 3 "grouping" color schemes.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"fecket" <ne*********@hotmail.com> wrote in message
news:cu********************************@4ax.com...

I have a subform which is a continous form and displays the content of
a table, with a subjext number, then a line of text, then a score. I
have used an option group to update the score as 0,2,4,6,8,10

When entering the data it is a bit difficult to keep track of where
you are, as you are transferring data from hard copy.

Is there a way to allocate a background colour to individual rows of
the subform to give an overall colour for each grouping. The question
subject numbers are from 200 - 300, 300 - 400 etc so a banded colour
scheme would help you keep track.

I have seen a routine for alternate colouring od lines, but I would
like to do it as a group and allocate a diferent colour to each.

Anyone an ideas ??

fecket