BackColor on one field in continous form

R

reidarT

I want to have 20 employees represent each a color.
I have made a color table with 20 different colors and I have a field in the
employee table representing this colorID.
How do I get this color to show in a continous form?
I have tried code 'on current' and 'form open'
This is not conditional formatting, I need at least 20 colors.

reidarT
 
A

Allen Browne

Not going to happen in a form.

If you set the color in the form events (such as Current) it will apply to
all rows.

(You can use the Format event of the section in a report.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing row background from external program 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Dynamic Naming of Form Button 3
Address Format changed after Migration 0
Dealing with a Pivot Table (when I don't want to) 0
Need help modifying code 0
Changing total on one row in Continous Form 7
Changing Form BackColor in VB 1

Top