Change colour on form for different names

B

Bryyan

Joined
Sep 4, 2006
Messages
8
Reaction score
0
Hi,

I have a textbox field [Trade] in a form and I want to make each different name (Pipefitter=green, BoilerMaker=Blue, IronWorker=yellow, SheetMetal=purple, Insulator=red,Scaffolder=orange)a different colour. I used the conditioning format but I can only get three different colours. There is a way in code but I don't know how to write it. It is something like this? On the after update event Trade.forecolour = "Pipefitter" vb green
Trade.forecolour = "BoilerMaker" vb Blue
Trade.forecolour = "IronWorker" vb yellow
Trade.forecolour = "SheetMetal" vb purple
Trade.forecolour = "Insulator" vb red
Trade.forecolour = "Scaffolder" vb orange
or there is some number to put instead of vb (colour) I'm not sure
Can someone help me.
Thanks Bryyan
 

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

Change forecolour according to text in a form 0
change the forecolour in my form based on certian text names 0
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
Need help creating macros 6
Excel High lightng dates in future, today and past 1
Column wrap a single field into 2 or more columns per page? 2
Change Flag Sort Order 1
Create List 7

Top