Change label colour

[todgers]

Ok what I would like to do is have a switchboard with a number of command buttons on, each button opens to a form with a few fields within them.

Is it possible for the initial switchboard labels to be 'red', then as the related form is opened and populated the switchboard label turns 'amber' and once the form is complete the switchboard label is 'green'. See example piccie attached, to get a better understanding!

This is to enable multiple users to see at a glance the status of various jobs.

If anyone knows how I can go about this or suggest any alternatives, I'm open to suggestion.

Thanks in advance

 

[gemma-the-husky]

if this is a continuous form, check out conditional formatting - available in Access 2K on, I think. BUt I find it a bit awkward to use. I don't think there's any other way to do it with a continuous form, because you only have one detail section, which Access fills with multiple rows.

 

[lightray]

Thinking outside the square, [minimal experience with switchboard], but could you make it an OLE field and conditionally change the display image? Tiny images and multiple usage.

 

[gemma-the-husky]

sorry, my misreading. if iits a switchboard i assume they are all buttons, so you can do whatever you want with the colours except that you can't change a buttons bgcolor, only the fgcolor.

however, you can click a label, and you can change the fg and bg color of labels, so that might be a way forward.

 

[GUIDO22]

I would simply use a series of text boxes and command buttons as shown on your sample screen. Set the backcolor for all the boxes to Black and when the appropriate command button is depressed - set the appropriate record in a 'Button status' table (you will need to create this table).

With a text box in the background - and a transparent one in the foregound and you can change the back colour of the background colour as you wish!
See the following link for further information - posting by OldSoftBoss :
http://www.access-programmers.co.uk/forums/showthread.php?t=95452&highlight=row+highlight

This gives an insight into how to highlight a row - maybe you can make some simple changes to this code as I have done for my own purposes - to suit your own needs.... Good luck!