Conditional Formatting a Combo Box based on Contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up conditional formatting on a combo box to where if the
combo box has more than 1 item in it, it will change its color. I can't
quite figure out how to write an expression for this though. I've tried
several methods, but it doesn't seem to like my VB. Any suggestions?

Thanks!

Nick
 
You shouldn't need any code. You can use conditional formatting with
Expression Is like:
combo0.ListCount>1
Change the combo box name to your combo box name.
 

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

Conditional formatting with combo box 7
filter query on combo box in a continuous subform 0
Controlling a list box population based on combo boxes 1
Conditional Formatting-HELP anyone?! 9
Combo box problem 3
Date format in a combo box 1
Conditional Formatting in Combo Box (ACC2007) 2
combo box fills in arbitrary value 7

Back
Top