You can do this kind of thing with Conditional Formatting with a Combobox, but not with a ListBox. If that alternative would work for you, in Form Design View:
- Select the Combobox then go to Conditional Formatting and use
- Expression Is
- Not IsNull([YourComboBoxName])
- Select the color formatting you want
- Click on OK
If you want the formatting to show immediately, instead of showing in reverse, as June7 explained it would, when a selection is made, you'd need to immediately move Focus elsewhere:
Code:
Private Sub YourComboBoxName_AfterUpdate()
Me.AnyOtherControl.SetFocus
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007