Combo Box starting value

[gmazza via AccessMonster.com]

Hey there,
I have a combo box with values, with one value being "None"
How can I get this value to be the first one to show up in my combo box. Asc
and Desc are not doing it for me.
Thanks!

 

[Jeff Boyce]

You don't mention how you are sorting the displayed values in your combobox.

You don't mention whether the combobox is based on a value list or on a
query (or a table).

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Daniel Pineault]

I depends on how you have set up your cbo.

One option is to add a column to your data source that has numeric value to
sort on.

None 1
All 2
.....
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Stuart McCall]

Hey there,
I have a combo box with values, with one value being "None"
How can I get this value to be the first one to show up in my combo box.
Asc
and Desc are not doing it for me.
Thanks!

(None)

or <None>

will both sort to the top of the list.

 

[gmazza via AccessMonster.com]

I have a query for my combo box and I am not currently sorting it at all. I
just want None to show up as the first choice.

 

[Stuart McCall]

I have a query for my combo box and I am not currently sorting it at all. I
just want None to show up as the first choice.

Well the only way I know of to achieve that without sorting is to change the
combo's rowsource type to 'value list', then fill it from a recordset based
on your query. That way you can put whatever you like as the 1st entry.

But I don't recommend it. It'll be slow compared to binding the combo to a
field. Personally I'd set the sort order in the query and use parens to get
None to the top.