Color Boxes in continious form or Datasheet

[Sean]

Dear All,

I have a table with many fields the relevant ones being
[Order],[Name],[RGB],[Color]. The table contains (at present) 16
records.

I would like to create a form which displays these fields (preferbally
in Datasheet view) where the [Color] field will show a box dependant on
it's respective [RGB] color.
I have tried the following so far :-
1) A textbox with a function that changes the .BackColor based on a
value. This simply changes the color of ALL the boxes (unless the form
is displayed as a single form)

2) Conditional formatting. This works but only for three possible colors
(and I have 16). I also tried putting a function similar to that in 1)
into the formatcondition, but no dice.

3) Create individual controls for each of the 16 color boxes. This is
time consuming and a bit of a pain if more records need to be added.
Individual controls seem to be the answer unless I am missing something.
In the long run I will want to use the Windows Common Dialog Controls to
select the color and simply store the RGB number, but first things first

Any ideas?
----
Sean
Just press the off switch, and go to sleep!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Darryl Kerkeslager]

Individual labels will work just fine, and have the lowest overhead. There
really shouldn't be too much to it. Just open your table, read the values,
and set the label properties according to the table.

Assume labels are name L1, L2, L3, etc.: (You could also use a control
array)

For x = 1 To 20
Me("L" & x).BackColor = rs.Fields("backcolor")
Next x

Darryl Kerkeslager

"Sean" <se*********@TimeaIntLtd.hu> wrote in message
news:41**********************@news.newsgroups.ws.. .

Dear All,

I have a table with many fields the relevant ones being
[Order],[Name],[RGB],[Color]. The table contains (at present) 16
records.

I would like to create a form which displays these fields (preferbally
in Datasheet view) where the [Color] field will show a box dependant on
it's respective [RGB] color.
I have tried the following so far :-

3) Create individual controls for each of the 16 color boxes. This is
time consuming and a bit of a pain if more records need to be added.

[Sean]

Thanks Darryl but that does not really solve my problem. I will try to
re-phrase it in more detail.

----
Sean
"Just press the off switch, and go to sleep!"

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!