Results 1 to 5 of 5
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    List Box Behaviour (Access 2000)

    I'm playing with my forms, trying to find ways that my users can "break" them, and I've noticed something about the behaviour of list boxes.

    I've set the list box to have a default value, but the user can scroll until another value is visible (I've sized the box so that only one option is visible), but unless they click on the visible value it isn't selected and as soon at they move to another record the value of the list box reverts to its' default value.
    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> I know this will cause trouble!
    Is there a way I can avoid this behaviour? Design change or property setting on the list box?
    Any advice would be welcome.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List Box Behaviour (Access 2000)

    Frankly, I doubt that a different type of behavior would be desirable. If just scrolling through the items of a list box would change the selection, the user wouldn't be able to browse.

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: List Box Behaviour (Access 2000)

    I've resized my listboxes, strikes me that I was being a little too space conservative.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: List Box Behaviour (Access 2000)

    Catharine,

    That's because if they select (click on) a value in the list, they change the value in the underlying field. If they just scroll the list, it doesn't change anything and the list has to display it's actual value. Trust me, you don't want to avoid this behavior. Then your users would not be able to see the true value of the control or they would change it by accident when they didn't mean to.
    Charlotte

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: List Box Behaviour (Access 2000)

    I know, it makes perfect sense when you say it. <img src=/S/blush.gif border=0 alt=blush width=15 height=15> Just wasn't thinking that way at the time. I think the larger size of list box will make it more obvious.

    Thanks
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •