color and continuous forms (again)

J

JamesSF

Ugh, this issue always seems to crop up.

i have a table with a status and a color - like

Color COstatus COcolor
1 16711680
2 32768
3 255


i want

me.fieldname.backcolor = dlookup("COcolor","Color","COstatus =
me.fieldname")

- but this doesnt work on a continuous form, it picks the first color
correctly then doesnt change for each line

any ideas??

thanks
james
 

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

How to color boxes in continuous subform? 3
Conditional Formatting in Sub-Form 0
Changing background color by record more than 3 colors 0
Changing color on continuous form 1
Default Value on Continuous Form 2
Changing field colors on a continuous form 1
CF Stop If True not working correctly 3
John Walkenbach Color Palette (Repost) 1

Top