Combo Box Values

M

Matt

I have my combo box's row source type as a table/query. The values included
in the combo boxes are from the access table. In this table, I have the
value "All Values" in one of the rows. I want to make sure that "All Values"
appears as the very first value in the combo box drop down. Is there a way
to position the combo boxes default value as the first value rather than a
sorted fashion? I guess my only other option is to add an underscore or
dash before "All Values".

Thanks,
Matt
 
T

Todd Shillam

Matt,

Try sorting in ascending order, and use brackets or parenthesis around "All
Values" -- the brackets or parenthesis should force your option to the top.

Best regards,

Todd
 
Top