By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

REQ: Formatting rows in a subform

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.