--
Is it possible to always have a blank row at the top of your dropdown list ,
to be able to select a blank, my list does have "Is Not Null"
Thanks for any help....Bob





..........Jenny Vance

You can use the same technique to add the "(All)" row in a ComboBox:

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

--
HTH
Van T. Dinh
MVP (Access)



"Bob" <(E-Mail Removed)> wrote in message news:elsfr6$lj1$(E-Mail Removed)...
>
>
> --
> Is it possible to always have a blank row at the top of your dropdown list
> , to be able to select a blank, my list does have "Is Not Null"
> Thanks for any help....Bob
>
>
>
>
>
> .........Jenny Vance
>

My Row source is:
QrySpellingList
this is the query:
SELECT DISTINCT qrySpelling.Spelling
FROM qrySpelling
WHERE (((qrySpelling.Spelling) Is Not Null));
So where would I add "(All)"
Thanks for any help..Bob

"Van T. Dinh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You can use the same technique to add the "(All)" row in a ComboBox:
>
> http://www.mvps.org/access/forms/frm0043.htm
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Bob" <(E-Mail Removed)> wrote in message news:elsfr6$lj1$(E-Mail Removed)...
>>
>>
>> --
>> Is it possible to always have a blank row at the top of your dropdown
>> list , to be able to select a blank, my list does have "Is Not Null"
>> Thanks for any help....Bob
>>
>>
>>
>>
>>
>> .........Jenny Vance
>>
>
>

Ah ha, I got it, take away "Is Not null" because I have Unique values I just
get one blank, thanks bob
"Bob" <(E-Mail Removed)> wrote in message news:elshkr$omo$(E-Mail Removed)...
> My Row source is:
> QrySpellingList
> this is the query:
> SELECT DISTINCT qrySpelling.Spelling
> FROM qrySpelling
> WHERE (((qrySpelling.Spelling) Is Not Null));
> So where would I add "(All)"
> Thanks for any help..Bob
>
> "Van T. Dinh" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> You can use the same technique to add the "(All)" row in a ComboBox:
>>
>> http://www.mvps.org/access/forms/frm0043.htm
>>
>> --
>> HTH
>> Van T. Dinh
>> MVP (Access)
>>
>>
>>
>> "Bob" <(E-Mail Removed)> wrote in message news:elsfr6$lj1$(E-Mail Removed)...
>>>
>>>
>>> --
>>> Is it possible to always have a blank row at the top of your dropdown
>>> list , to be able to select a blank, my list does have "Is Not Null"
>>> Thanks for any help....Bob
>>>
>>>
>>>
>>>
>>>
>>> .........Jenny Vance
>>>
>>
>>
>
>