Continuous form with conditional formating (3 conditions)

[j0se]

Hi people,

There's a few good examples here about continuous forms with con formating, but they all alternate between 2 colours.

I have a continuous form, showing some fields - one of which is a status field. There are 3 statuses and so I want to colour each status differently.

I succeeded using access's own conditional formating tool, but this only lets me apply the formating to the textbox in question (as far as I can tell)

I can do it coding this:

If status = "Status 1" then
status.BackColor = vbred
anothertextbox.BackColor = vbred
yetanothertextbox.BackColor = vbred
end if
... and so on

but this is applied to the each row in the continuous form, as opposed to each one individually

Can anybody point me in the right direction please?

Thanks for all your help!

 

[namliam]

Have a looksee here
http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=252553#post252553

that may help (i havent done it myself)

 

[j0se]

Already seen this

Actually, it turns out the in-built con formating tool does what I need

cheers anyway!