Combo Box starting value
in [Forms]
|
Prev: Odd Error
Next: odd issue with word help file
From: gmazza via AccessMonster.com on 24 Feb 2010 18:41 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! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201002/1
From: Jeff Boyce on 24 Feb 2010 19:23 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. "gmazza via AccessMonster.com" <u37142(a)uwe> wrote in message news:a4225252959ed(a)uwe... > 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! > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201002/1 >
From: Daniel Pineault on 24 Feb 2010 19:52 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. "gmazza via AccessMonster.com" wrote: > 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! > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201002/1 > > . >
From: Stuart McCall on 24 Feb 2010 20:28 "gmazza via AccessMonster.com" <u37142(a)uwe> wrote in message news:a4225252959ed(a)uwe... > 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! > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201002/1 (None) or <None> will both sort to the top of the list.
From: gmazza via AccessMonster.com on 25 Feb 2010 10:17
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 wrote: >> 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. -- Message posted via http://www.accessmonster.com |