How to use record RGB Values to set a form field backcolor?

[isladogs]

Did you look at the example app I showed in post #7?
That works in continuous forms and in principle allows up to 256*256"256 colour combinations - almost 17 million.

[JohnGeeee]

Did you look at the example app I showed in post #7?
That works in continuous forms and in principle allows up to 256*256"256 colour combinations - almost 17 million.

Hi Isladogs
I am starting to have a deeper look at it. I see it properly now, my eyes have been opened. It is very smart and I can see that the princple behind it should get me further headed in the right direction. I just have to digest it and work out how it works. I have made Access databses for many years but never got into VBA from scratch to work real magic. But this has helped my learning greatly. Many thanks for your help!

PS. Does anyone else have typing problems in this forum? It is like my keyboard is broken and ever other character does not type out?

[isladogs]

Hi Isladogs
I am starting to have a deeper look at it. I see it properly now, my eyes have been opened. It is very smart and I can see that the princple behind it should get me further headed in the right direction. I just have to digest it and work out how it works. I have made Access databses for many years but never got into VBA from scratch to work real magic. But this has helped my learning greatly. Many thanks for your help!

PS. Does anyone else have typing problems in this forum? It is like my keyboard is broken and ever other character does not type out?

No to the second question ...

The colour values are stored in a table and can be used for back colour or fore colour. Feel free to ask if you don't understand how the method works

Whilst conditional formatting could be used instead, I find this approach easier when there are a lot of formats required
For example, I often use the approach for colouring different categories of calendar events.



The student grades form below also uses the same method. It is taken from the Colour conditions app on my website



Hope that helps

[JohnGeeee]

Hi Helpers
I am so excited! With your help I got it to work. I now have a continuous form that shows colour of each record item to the relevant RGB values and I can sort the colours by clicking on any other Colour column and using ascend and descend. I finaly figured out that the code had to go in a Private Sub Detail_Paint() section of the Form Code for each seperate record to be its own colour. That is the basic part done now I can go on to build my color tool.

Thanks Everone
John G