Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

listbox formatting

Discussion in 'Information Technology' started by bkrasnof@gmail.com, Jul 28, 2006.

  1. bkrasnof@gmail.com

    bkrasnof@gmail.com
    Expand Collapse
    Guest

    Hi, I'm using access2003 and I have a listbox on a form. When I expand
    the listbox it displays nicely....bound to column 1, but displays colum
    2.

    But before it's expanded the listbox always displays the bound column,
    column 1, even though I have set the width to 0".

    Is there a way I can have it display column 2 in both 'modes'?

    thanks,
    Bruce
     
  2. tina

    tina
    Expand Collapse
    Guest

    sounds like you're talking about a combo box control, not a listbox control.
    a combo box control shows the "droplist" only when you click the arrow
    button at its' right edge, or press F4, while the listbox is "open" all the
    time.

    the behavior you're describing sounds strange, though. if the ColumnCount
    property is set correctly, and the BoundColumn property too, and the
    ColumnWidths property has a width for every column, starting with
    0"
    for the first (and bound) column, then the control should show the value in
    the second column whether the droplist is open or not.

    is the control bound to a field in the form's underlying table - in other
    words, is there a field name in the control's ControlSource property? if
    not, is there *anything* in the ControlSource property? is there a value in
    the control's DefaultValue property? if the control is bound to a field,
    then is that field a Lookup field in the table? if so, get rid of the Lookup
    at the table level (for more information, see
    http://home.att.net/~california.db/tips.html#aTip8).

    hth


    <bkrasnof@gmail.com> wrote in message
    news:1150630843.117134.126580@y41g2000cwy.googlegroups.com...
    > Hi, I'm using access2003 and I have a listbox on a form. When I expand
    > the listbox it displays nicely....bound to column 1, but displays colum
    > 2.
    >
    > But before it's expanded the listbox always displays the bound column,
    > column 1, even though I have set the width to 0".
    >
    > Is there a way I can have it display column 2 in both 'modes'?
    >
    > thanks,
    > Bruce
    >
     
  3. bkrasnof@gmail.com

    bkrasnof@gmail.com
    Expand Collapse
    Guest

    Hi Tina,

    Yes, I tried combobox and it worked fine, the way I expected.

    I did have a controlsource set to a field in the table, but it wasn't a
    lookup field. I've avoiding those.

    I'll use combobox for now, just seems like it might be an obscure
    listbox bug, or more likely something I'm doing wrong :)

    But the same configuration worked fine with a combobox.

    -Bruce

    tina wrote:
    > sounds like you're talking about a combo box control, not a listbox control.
    > a combo box control shows the "droplist" only when you click the arrow
    > button at its' right edge, or press F4, while the listbox is "open" all the
    > time.
    >
    > the behavior you're describing sounds strange, though. if the ColumnCount
    > property is set correctly, and the BoundColumn property too, and the
    > ColumnWidths property has a width for every column, starting with
    > 0"
    > for the first (and bound) column, then the control should show the value in
    > the second column whether the droplist is open or not.
    >
    > is the control bound to a field in the form's underlying table - in other
    > words, is there a field name in the control's ControlSource property? if
    > not, is there *anything* in the ControlSource property? is there a value in
    > the control's DefaultValue property? if the control is bound to a field,
    > then is that field a Lookup field in the table? if so, get rid of the Lookup
    > at the table level (for more information, see
    > http://home.att.net/~california.db/tips.html#aTip8).
    >
    > hth
    >
    >
    > <bkrasnof@gmail.com> wrote in message
    > news:1150630843.117134.126580@y41g2000cwy.googlegroups.com...
    > > Hi, I'm using access2003 and I have a listbox on a form. When I expand
    > > the listbox it displays nicely....bound to column 1, but displays colum
    > > 2.
    > >
    > > But before it's expanded the listbox always displays the bound column,
    > > column 1, even though I have set the width to 0".
    > >
    > > Is there a way I can have it display column 2 in both 'modes'?
    > >
    > > thanks,
    > > Bruce
    > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page