Color a Continuous form row without CF

[disneygoof via AccessMonster.com]

Greetings to all...

I am back with yet another question. I have read all sorts of "stuff" on
this site and I have looked at the mdb's on Stephen Lebans site (way over my
head)...

Like many others, I am looking to take a number of different colors (8 to be
exact) and based on user criteria, color a continuous row record.

For example.
I have a subform within a main form. The subform contains many records,
we'll call them "tasks to perform". Sometimes there is few "tasks to
perform" and sometimes many "tasks to perform". I need to color records
based on the following criteria:

1. item is completly done - yellow
2. item is almost complete - cyan
3. item is on hold - magenta
4. item is cancelled - red
5. item is by others1 - some form of blue
6. item is by others2 - some form of green
7. item is by others3 - some form of orange
8. item is in review - some form of pink

the actual colors might be different and I may need to add more in the future,
but you get the jist of what I am trying to do..I hope? I was using
datasheet form and was told "if you want more color features to use
continuous form"...well, I can get it to work at all.

I sure could use some advice...
Thank you,
David

 

[Peter Hibbs]

David,

Conditional Formatting only allows you to have three different colors
on a Continuous form. An alternative is to use a Flex Grid control
instead of the Continuous form that you have at the moment. This would
allow you to have any number of colors for each row or individual
cells. The problem is that you would need to write a bit of VBA code
to use this option which may be 'way over your head' as well. Have a
look at my Flex Grid demo program at :-

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

for some examples. If this looks like what you want I may be able to
help with the VBA code, it's not that difficult.

HTH

Peter Hibbs.

 

[disneygoof via AccessMonster.com]

Peter,

The demo looks awesome, but yes, a bit over my head. In time I might learn
how to use it, but time is something I don't have. Thanks for the info.

David

David,

Conditional Formatting only allows you to have three different colors
on a Continuous form. An alternative is to use a Flex Grid control
instead of the Continuous form that you have at the moment. This would
allow you to have any number of colors for each row or individual
cells. The problem is that you would need to write a bit of VBA code
to use this option which may be 'way over your head' as well. Have a
look at my Flex Grid demo program at :-

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

for some examples. If this looks like what you want I may be able to
help with the VBA code, it's not that difficult.

HTH

Peter Hibbs.

Greetings to all...

[quoted text clipped - 28 lines]

Thank you,
David

 

[Peter Hibbs]

David,

Fair enough. Just post back when you are ready to have a go at using
the flex grid control.

Peter Hibbs.

Peter,

The demo looks awesome, but yes, a bit over my head. In time I might learn
how to use it, but time is something I don't have. Thanks for the info.

David

David,

Conditional Formatting only allows you to have three different colors
on a Continuous form. An alternative is to use a Flex Grid control
instead of the Continuous form that you have at the moment. This would
allow you to have any number of colors for each row or individual
cells. The problem is that you would need to write a bit of VBA code
to use this option which may be 'way over your head' as well. Have a
look at my Flex Grid demo program at :-

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

for some examples. If this looks like what you want I may be able to
help with the VBA code, it's not that difficult.

HTH

Peter Hibbs.

Greetings to all...

[quoted text clipped - 28 lines]

Thank you,
David

 

[disneygoof via AccessMonster.com]

Peter,

Thanks, I will.

David

David,

Fair enough. Just post back when you are ready to have a go at using
the flex grid control.

Peter Hibbs.

Peter,

[quoted text clipped - 27 lines]