Text Box BackColor different for each row in continuous form

[GazMathias]

Hi Guys,

Anyone know if this is possible?

I have a need to display multiple colours in a subform, next to a colour reference name. My row source includes the RGB values (intColorRed, intColorBlue, intColorGreen).

I currently have the subform set up with the colour name and an unbound text box which I can easily recolour using

Me.ColourPreview.BackColor = RGB( (Me.the vars above) )

I can't figure out how to make each one adhere to its RGB settings, changing one changes them all, now matter which event I use.

Any insights are much appreciated.

[JustJim]

@GazMathias
Check out Stephen Lebans sample DB here which might be of help.

Also a previous Bytes discussion here.

Jim

[FishVal]

@JustJim
Conditional formatting allows up to 3 different formats only.

@Gaz
No way with subform. Use an other control.

P.S. I see at least three candidates to this role: MSComCtl.ListView, MSComCtl.TreeView, OWC11.Spreadsheet.

[GazMathias]

@FishVal
Thanks Fish' I'll check those out!

Gaz.

[NeoPa]

That's a tough one Gaz.

Although bound controls can display different values according to what's in the dataset record, Access only has one instance of the control itself. This means that all versions seen on the form reflect the same attributes until you change something, when all change to reflect that of course.

[FishVal]

Just a thought.
If you use Access 2007, you may see what could be done using bound Image control (in a case when color list is not expected to change) or rich text control.

[GazMathias]

Thanks for your efforts guys, I have now decided to write the system as a web application. This solves the issue. I should have stated before also that the parent record to that above could have multiple instances of the colourways and I would need to draw them all!

So much simpler to just loop the data into a table, convert the RGB values to hex and write them to a td's style.

Gaz