Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    ohmydatabase's Avatar
    ohmydatabase is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    79
    Solution / Lessons Learned:



    When populating a multi-column listbox, it is much better to set the RowSourceType = "Table/Query" than it is to use a "Value List". I was having issues with populating the multi-column listbox with various string literals and other pieces of data. I was having issues with escape characters, or characters in the string literal would act as delimiting characters. Adding escape characters worked to some extent, but required much more manipulation and code. I actually hit a point where my wrap/escape characters would not properly delimit my addition string. All my columns were shifted over at these delimiting characters.

    I changed my RowSourceType to "Table/Query" per the advice of @June7 and this has solved my problem!

  2. #17
    ohmydatabase's Avatar
    ohmydatabase is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    79
    Quote Originally Posted by June7 View Post
    If you just want the value in the listbox box after an item is selected, simply reference the listbox.

    x = Me.myListBox
    In a multi-column ListBox, will this always select the first field of that row? What would I need to do to select other columns (fields)?

  3. #18
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    It should reference the data according to whichever is the bound column. That usually defaults to the first column, but it doesn't have to be.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Special Delimiter characters
    By cliff.clayman in forum Import/Export Data
    Replies: 12
    Last Post: 09-13-2016, 10:52 AM
  2. Removing special characters
    By crowegreg in forum Queries
    Replies: 3
    Last Post: 02-26-2014, 11:56 AM
  3. Search for special characters
    By davej311 in forum Queries
    Replies: 3
    Last Post: 11-20-2013, 02:35 PM
  4. Need to delete special characters
    By tlrutledge in forum Queries
    Replies: 1
    Last Post: 08-23-2013, 03:10 AM
  5. Special Characters
    By orgelizer in forum Access
    Replies: 0
    Last Post: 03-20-2007, 08:24 PM

Tags for this Thread

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