Conditional Formatting of Toggle Button in Access
Posted on 2013-05-16
I haven't used Access in several years and have recently inherited an Access 2003 "Call In Log" application that has 22 toggle buttons on the front page. Each button is bound to a yes/no field in the database. The users click each one of these buttons that apply to the reason the customer is calling. They are not in an Option Group. By default, as you scroll through records in a form, Access toggle buttons show depressed when the record is true in the table. Now the user wants to make the "depressed" look more obvious to all of the users; by either changing the font color, boldness, back color, etc. I've tried putting this code in the OnOpen event for the form:
Private Sub Form_Open(Cancel As Integer)
If [How to Order].Value = True Then
[How to Order].ForeColor = vbRed
Else: [How to Order].ForeColor = vbBlack
That does change the color of the text on this particular button, but it changes for every record from that point forward whether the button is selected or not. What event is triggered when a record changes on a form? Would that be the place to put this code?
I also wanted to try the Conditional Formatting for each button, but Conditional Formatting is greyed out in the Format menu.