Results 1 to 3 of 3
  1. #1
    Gabriel2012 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2012
    Posts
    31

    Field Visibility In Combo Box

    Hello, I have the "First" and "Last" name field visible when selecting an option from a combo box. However when it is selected only the first field populates and remains visible. How can I set this so that both fields remain visible in the box? Neither of them are the bound column.



    See below....

    Thank you kindly
    Attached Thumbnails Attached Thumbnails untitled.JPG  

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In your SQL for the lookup, add a column and concatenate the first and last, ie. FullName: First &" "& Last
    In your properties for the combo box, set the number of columns to 4, assuming you have a record ID. Set the column widths to 0;0;0;1

  3. #3
    Gabriel2012 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2012
    Posts
    31
    That worked splendidly, thank you

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

Similar Threads

  1. Field visibility in a report
    By PhilTFC in forum Forms
    Replies: 8
    Last Post: 10-29-2012, 12:10 PM
  2. Field Visibility
    By cbrsix in forum Programming
    Replies: 3
    Last Post: 06-27-2012, 03:52 PM
  3. Replies: 8
    Last Post: 01-25-2012, 02:07 PM
  4. [Access2003/2010] Cascading combo box visibility
    By sublevelmonkey in forum Programming
    Replies: 7
    Last Post: 01-19-2012, 10:39 AM
  5. Visibility based on Combo selection
    By jlclark4 in forum Forms
    Replies: 1
    Last Post: 12-22-2010, 11:42 AM

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