Results 1 to 4 of 4
  1. #1
    VirgilMachine is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    11

    Width of combo box pull-down

    This may be answered here, but I can' think of a reasonable way to search for it...I'm not finding it...so I apologize if I'm being redundant.

    I have a simple form for a clients tab, with a sub form for a cross-reference table that links clients and events. The cross-reference table has lookup fields for event-type and location. On the subform, I use a query to populate a single combo box with date/type/location concatenated. This all works fine.

    When I want to add a new event for a client, I use the pull-down arrow to select the appropriate events. This also works, but the concatenated field is truncated on the right so I only see the date and part of the type. The add works, the only problem is that I would like the user to see the full description, and I can't see how to do that.

    Can someone direct me to a solution?



    Thanks.

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Resize the combo box with the "width" property.

    With your form in "Design" view, highlight the combobox, and look at the property sheet.
    The width property is near the top of the list.

  3. #3
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Did you try to stretch it with the cursor?

    That should have worked.

  4. #4
    VirgilMachine is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    11

    Thanks

    I knew it was simple. Actually, it was the "column width" property. I had to increase the one for the concatenated field and change the others to 0.

    The field was displaying properly ion the form, it was only when I used the pick list to select a new event or update an existing on where I had the problem.

    Thanks for the help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-08-2013, 03:37 AM
  2. Width problem
    By Trojnfn in forum Access
    Replies: 3
    Last Post: 10-19-2011, 07:14 PM
  3. Combo Box dropdown to size width of columns
    By noweyout in forum Forms
    Replies: 1
    Last Post: 02-18-2011, 05:56 AM
  4. The section width is greater than the page width?
    By Gary_Marshall in forum Reports
    Replies: 2
    Last Post: 11-13-2009, 01:54 PM
  5. Replies: 0
    Last Post: 12-19-2006, 09:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums