Conditional formatting on datasheet - more than 3 options?

[RickDB]

Say I had a list of 20 employees, they can be the employee who entered a record, say that someone told me that their initials were not enough, and they want each employee to be a different color in their field on the subform datasheet.

How do you do this? Conditional formatting only offers 3 criteria, can someone tell me if this is possible and direct me to a post that deals with this? I had no luck searching for one.

Thank you.

 

[freakazeud]

re:

Hi,
I'm not sure if you want to do that. Do you mean that each employee would have their own color? What happens if you have about 50 or more employees...at some point you are going to run out of colors which you can visually seperate. If you want a more readable interface then why not shade every other row in a different color instead.
HTH
Good luck

 

[RickDB]

Believe me, I would rather not have to mess with it, but *someone* seems bent on having the feature, to the point where he thinks that it would just be better to create ANOTHER Excel spreadsheet to redundantly ener the data into so it looks pretty.

At this point in learning about Acces I am all about form over function myself, but hey, I only work here!

 

[gemma-the-husky]

Rick - you will struggle with this in any continuous forms, as you only have the conditional formatting options, but if you are using single forms, then theres no reason why you cant change either the form's background colour or indivdiual controls to suit.

Put a colour in the employee table, then in a single form using this table you have their colour at your disposal. Only trouble is their are only a few colour constants vbred, vbyellow etc. You can store longint colour values if you can work them out. Other problem is that some colours will look awful on the screen.

 

[Oldsoftboss]

Other problem is that some colours will look awful on the screen.

Give them to the workers you dont like