Results 1 to 4 of 4
  1. #1
    manics31 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Location
    Philadelphia
    Posts
    23

    List Box to Text Box

    Hello all, is there a way to add multiple values selected from a list box to a text box?
    such as like: a list box selection of three items and have them appear in the text box as:
    Selection 1, Selection 2 and so on.
    I know i can have one value appears in the text box via
    Code:
    Me.TextBox=Me.ListBox.Column (0)
    but only one selection appears not multiple like i need it.
    any help will be greatly appreciated.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    You can adapt this to put strWhere into the textbox:

    http://www.baldyweb.com/multiselect.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    manics31 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Location
    Philadelphia
    Posts
    23
    Quote Originally Posted by pbaldy View Post
    You can adapt this to put strWhere into the textbox:

    http://www.baldyweb.com/multiselect.htm
    That did it.
    Thanks a million.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 2
    Last Post: 03-07-2018, 11:00 PM
  2. Replies: 8
    Last Post: 12-13-2017, 10:38 AM
  3. Use List box to populate text box with existing text
    By Stephenson in forum Programming
    Replies: 5
    Last Post: 10-07-2016, 10:07 PM
  4. Search List Box with Text Box
    By dalton in forum Access
    Replies: 6
    Last Post: 01-30-2013, 09:58 AM
  5. list and text box??
    By Zugalug in forum Forms
    Replies: 2
    Last Post: 10-04-2011, 10:53 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