Prev: Odd Error
Next: odd issue with word help file
From: Stuart McCall on 25 Feb 2010 13:31
"gmazza via AccessMonster.com" <u37142(a)uwe> wrote in message
news:a42a7cf1e340e(a)uwe...
>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
>

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.


First  |  Prev  | 
Pages: 1 2
Prev: Odd Error
Next: odd issue with word help file