Control Button Colors

  • Thread starter Thread starter Tony Uythoven
  • Start date Start date
T

Tony Uythoven

I have a form with several control buttons, whose foreground color I want to
be determined by flags stored in the database. For example, if the flag
associated with a control is TRUE, the color should be red, if FALSE green.

My program version is MS Access 2000/2002. Is there code for this function?
 
Tony,

The code could look something like this...

If Me.YourFlagger
Me.YourCommandButton.ForeColor = vbRed
Else
Me.YourCommandButton.ForeColor = vbGreen
End If

You will need to determine which event(s) are applicable to this. Maybe
the On Current event property of the form, and also the After Update
event property of the Flagger?
 
You must log in or register to reply here.

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Color Values Not Showing Properly 6
Control Background Color 2
Access Remove rows based on multiple fields 2
active combobox - possible to configure as display value andcoordinate value? 3
run-time error 2166 - can't lock control ??? 0
Can I create a new flag for Inbox messages in Outlook 2002 1
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21

Back
Top