Can"t create "drop-down list box"
Can"t create "drop-down list box"
am 18.11.2007 23:38:35 von Doug
Hi,
I can't figure out how to create a drop-down list box. The help file
says it exists. The icon in the help file matches the combobox in the
toolbox. I tried using a combox box, both with and without using the
wizard, and it will not "drop-down" - the list is horizantal. I don't
see a variable to set to change that. I tried the listbox in the
toolbox, and it is also horizantal (tried that first). The behavior I
want is to list, drop-down, 4 short values (simultaneously, no
scrolling needed), and when I select one to display the selected value
in the listbox, and set a value in a table to the selected value.
Thanks.
(MS Access 2000)
Re: Can"t create "drop-down list box"
am 19.11.2007 00:28:56 von John Spencer
If you did the items in the dropdown list by typing in values, did you
separate the values with a comma or with a semi-colon?
Did you specify the number of columns as 1?
'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Doug@NoEmail.com wrote:
> Hi,
>
> I can't figure out how to create a drop-down list box. The help file
> says it exists. The icon in the help file matches the combobox in the
> toolbox. I tried using a combox box, both with and without using the
> wizard, and it will not "drop-down" - the list is horizantal. I don't
> see a variable to set to change that. I tried the listbox in the
> toolbox, and it is also horizantal (tried that first). The behavior I
> want is to list, drop-down, 4 short values (simultaneously, no
> scrolling needed), and when I select one to display the selected value
> in the listbox, and set a value in a table to the selected value.
>
> Thanks.
>
> (MS Access 2000)
Re: Can"t create "drop-down list box"
am 19.11.2007 00:57:05 von Doug
I changed the columns to 1, and now it works like a drop-down list.
(I thought columns referred to the number of items...)
Thanks.
On Sun, 18 Nov 2007 18:28:56 -0500, John Spencer
wrote:
>If you did the items in the dropdown list by typing in values, did you
>separate the values with a comma or with a semi-colon?
>
>Did you specify the number of columns as 1?
>
>
>
>'====================================================
> John Spencer
> Access MVP 2002-2005, 2007
> Center for Health Program Development and Management
> University of Maryland Baltimore County
>'====================================================
>
>
>Doug@NoEmail.com wrote:
>> Hi,
>>
>> I can't figure out how to create a drop-down list box. The help file
>> says it exists. The icon in the help file matches the combobox in the
>> toolbox. I tried using a combox box, both with and without using the
>> wizard, and it will not "drop-down" - the list is horizantal. I don't
>> see a variable to set to change that. I tried the listbox in the
>> toolbox, and it is also horizantal (tried that first). The behavior I
>> want is to list, drop-down, 4 short values (simultaneously, no
>> scrolling needed), and when I select one to display the selected value
>> in the listbox, and set a value in a table to the selected value.
>>
>> Thanks.
>>
>> (MS Access 2000)