Combo Box Values

[Guest]

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

 

[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

 

[Larry Daugherty]

Hi Matt,

Look here for an answer:

http://www.mvps.org/access/forms/frm0043.htm

HTH