Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo List (Access 2003)

    Thank you very much Hans for your help. I can't thank you enough for all the assistance you have given me through the years.
    But...............I have another question.....I have a combo box that the user can select a name from - first and last - in separate fields. When they select a name it only shows the first name - how do I get the field to show the first and last name? Thanks again

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

    Re: Combo List (Access 2003)

    Although the dropdown list part of a combo box can display multiple columns, the text box part always displays only the first column with non-zero width. So if you want the text box part to display the full name, you must concatenate the first and last names in one field of the Row Source, for example as

    [FirstName] & " " & [LastName]

    or

    [LastName] & ", " & [FirstName]

Posting Permissions

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