Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Want Dropdown List wider than Window

Discussion in 'Information Technology' started by Bob, Jul 28, 2006.

  1. Bob

    Bob
    Expand Collapse
    Guest

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


    Thanks in advance.........Bob Vance
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News How The Left & Indian Nationalists Distorted The History Of Sikh Gadhar Movement - Breaking News Sep 21, 2016
    Interfaith Materialists And Its Discontents Interfaith Dialogues Jun 10, 2016
    Sikhi Quasi-Pragmatists And Quasi-Spiritualists, Care To Explain? Sikh Sikhi Sikhism Jun 6, 2016
    Cholesterol Is Finally Officially Removed From "naughty List" Health & Nutrition Feb 11, 2016
    Listening to Gurbani while driving?? Sikh Rehat Maryada Jan 13, 2016

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    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

    --
    Wayne
    Manchester, England.



    "Bob" wrote:

    >
    >
    > How can I Make the dropdown list wider the window above it, Has it something
    > to do with Alignment!
    >
    >
    > Thanks in advance.........Bob Vance
    >
    >
    >
     
  4. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    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."

    --
    Wayne
    Manchester, England.
     
  5. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Re: Want Dropdown List wider than Window -- Combobox Example

    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
    *



    Bob wrote:
    > How can I Make the dropdown list wider the window above it, Has it something
    > to do with Alignment!
    >
    >
    > Thanks in advance.........Bob Vance
    >
    >
     

Share This Page