Placing a check mark in a combo box

  • Thread starter Thread starter Rashar Sharro via AccessMonster.com
  • Start date Start date
R

Rashar Sharro via AccessMonster.com

Hi,

I have a combo box that uses a query to populate customer name, address
city. Upon selecting a customer name from the list, my sales totals
information correspond to the customer name that I select. What I would
like to do is click on the drop down list and be able to see a checkmark
beside the names of those who do not have a total of 0 sales.

I tried to use the conditional formatting option to see if i could
highlight those that do not have 0 for sales, but my syntax is incorrect.

For the conditional formatting, I am using expression.

My syntax are as follows... iIF (Sales_Total) <> 0 Then

(and then I would select my format option).
Any help would be greatly appreciated.

Thanks
 
The combo box itself won't do this. If you have more than one column in the
combo box and the displayed column in not the Bound Column, then you could
possibly manipulate the query for the Row Source to do this. I don't see an
ASCII character that you could use with Chr() to get a checkmark. You could
use another keyboard character though, such as *, to highlight the entry.

You would need to make the displayed column a calculated field in the Row
Source's query.

Example:
HighlightName: IIf(DCount("[FieldName]", "[TableName]", condition) = 0, "* "
& [NameField], [NameField])

Supply the needed condition to get the information for the current name.
 
Back
Top