Results 1 to 4 of 4

Thread: [RESOLVED] Access and combos

  1. #1

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Resolved [RESOLVED] Access and combos

    Hiya,

    Had a chunk of code for years now which is not doing what it used to do with combo lists.

    It is meant to fill a combo box from an array and deal with the column widths. It had been until today when I am doing stuff with it and the widths aren't changing. In combos. In listboxes the code works the way it should.

    I have attached a pic - minus data.
    The dividor line should be way more to the right.
    I changed the drop list to be bigger than the combo and that has a gap instead of filling it.

    Yet the same code works fine in a list box.

    Has MS fixed 'something' recently..?

    Coding is convaluted and a mash of older code plus stuff found online from MS site. I've put it all in a class which i then call.

    If you have come across this and know of a fix - I would be grateful.
    If your fix is to stop coding in Access, although I will acknowledge you are right, I wont be as gratef ul
    Attached Images Attached Images  

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

  2. #2
    Head Hunted anhn's Avatar
    Join Date
    Aug 2007
    Location
    Australia
    Posts
    3,669

    Re: Access and combos

    You can change the column widths as you want.
    Attached Images Attached Images  
    • Don't forget to use [CODE]your code here[/CODE] when posting code
    • If your question was answered please use Thread Tools to mark your thread [RESOLVED]
    • Don't forget to RATE helpful posts

    • Baby Steps a guided tour
    • IsDigits() and IsNumber() functions • Wichmann-Hill Random() function • >> and << functions for VB • CopyFileByChunk

  3. #3

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Access and combos

    Nope. Tried that. I remembered that before I could use that to force it to what I wanted. But it looks like the code some how overrides it but still doesn't get it right.

    Anything else to try?

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

  4. #4

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Access and combos

    After erasing and recreating the combo. Playing with settings. Examining the code again, and trying an experiment - it works again (phew).

    Thanks for the pointers

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

Posting Permissions

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



Click Here to Expand Forum to Full Width