Change forecolour according to text in a form

B

Bryyan

Joined
Sep 4, 2006
Messages
8
Reaction score
0
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. Is there a way in code to make the 6 different colours as per the above. I read something about a Case Select. Even if somebody knows about an example on a site I could go to.
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 colour on form for different names 0
change the forecolour in my form based on certian text names 0
change captions with conditional formatting 2
In a query only filter by a variable if it has a value 2
Compare two datasheets and create a new one with modified and newinformation - Excel 1
Change color on date field in form for re-certification 1
Colouring individual fields in a multiple row form 2
different colors for bars in a column chart 2

Top