Results 1 to 4 of 4

Thread: RESOLVED: Access combobox style

  1. Jun 18th, 2004, 05:23 AM #1
    deeperdish
    deeperdish is offline

    Thread Starter
    New Member
    Join Date
    Jan 2004
    Location
    London
    Posts
    10

    RESOLVED: Access combobox style

    Is it possible to set the style of a combobox on an access form to dropdown only?

    I dont want users to be able to edit or type in the combobox...

    I have tried using code to set the combobox.style to 2, but I get an error (method or data member not found).

    There's also no option to change this property on the properties list.

    Any ideas?!?!
    Last edited by deeperdish; Jun 18th, 2004 at 05:50 AM.
    Reply With Quote Reply With Quote
  2. Jun 18th, 2004, 05:31 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    Properties > Data Tab > Limit to List - Yes
    Limits the list to only that which is in the list.

    Also errors with Access itself if users attempt to enter something which is not in the list. Nothing you can do about that - its stupid users in that particular case heheh

    joking

    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Jun 18th, 2004, 05:38 AM #3
    deeperdish
    deeperdish is offline

    Thread Starter
    New Member
    Join Date
    Jan 2004
    Location
    London
    Posts
    10
    Thanks for that.

    I have enabled that option, but it doesn't stop users from being able to type stuff in the box.

    I really just want them to "click and pick"...
    Reply With Quote Reply With Quote
  4. Jun 18th, 2004, 05:49 AM #4
    deeperdish
    deeperdish is offline

    Thread Starter
    New Member
    Join Date
    Jan 2004
    Location
    London
    Posts
    10
    I've just added some error handling around that code to bypass the error messages.

    So now if the user types anything that's not in the list and hits enter, it just tells them to pick from the list.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width