Want Dropdown List wider than Window

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

How can I Make the dropdown list wider the window above it, Has it something
to do with Alignment!


Thanks in advance.........Bob Vance
 
Hi Bob

No really sure what you mean by "window above it" but I think you mean the
un-expanded combo.
So
Set the combo (fotmat menu) width at what ever you want and set the the (all
menu) set the column widths the a larger number. At the long as the 2nd fig
is larger than the 1st you will make the "dropdown wider than the window
above it."

Hope this helps
 
Hi (again) Bob

Sorry about the almost unreadable last post. English isn’t my first language.

Sono italiano – me dispiace.

It should have siad -
__________________________________

Not really sure what you mean by "window above it" but I think you mean the
un-expanded combo.
So
Set the combo width, on the “format†menu, at what ever you want and on the
“all†menu set the column widths at a larger number. As the long as the 2nd
figure is larger than the 1st you will make the "dropdown wider than the
window above it."
 
Hi Bob,

here is an example with the properties you need to set for a combobox

~~~ Combobox Example ~~~

* Under no circumstances should you store names in more than one
place. For instance, if you have a People table, define a PID (or
PeopleID) autonumber field. Then, in other tables, when you want to
identify a person, you can use the key field. One way to do this…

Create an autonumber field in the People table -->

PID, autonumber

then, in the other tables...
PID, long, DefaultValue = Null

Then, when you want to put data in (which should be done from a form),
you can set it up to pick names from a list but store the PID.

create a combobox control

Name --> PID

ControlSource --> PID

RowSource -->
SELECT
PID,
LastName & " " & Firstname AS Fullname,
BirthDate
FROM People
ORDER BY LastName, Firstname

BoundColumn --> 1

ColumnCount --> 3

columnWidths --> 0;2;1
(etc for however many columns you have -- the ID column will be hidden)

ListWidth --> 3
(should add up to the sum of the column widths)

if you have a listbox, make the width .01 MORE than the sum of the
columns to prevent the horizontal scrollbar.


PID will be stored in the form RecordSource while showing you names from
another table... a MUCH better and more reliable method.

If you want to show other information from your combobox in other
controls, you can use calculated fields.

For instance

textbox:
Name --> BirthDate
ControlSource --> = PID.column(2)

The reason that column 2 is referenced instead of column 3 is that
column indexes start with 0, not 1, in Access

~~~~~~~~~~~`

to answer your question, the property that controls the width of the
list is ListWidth


Warm Regards,
Crystal
*
(: have an awesome day :)

*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top