J
JustinBailey
I have a form with a two-column listbox on it. The first column shows the
invoice number and the second column displays the (text) description. The
user types some text into a textbox, clicks Search, and the matching results
display in the listbox. Recently a record was added where the description
contained a semicolon. The description text beyond the semicolon does not
appear in the listbox. Subsequent records display... oddly. For example,
Table1
001 | Apple
002 | Banana; Cantelope
003 | Date
Listbox1
001 | Apple
002 | Banana;003;
Any suggestions on how to make this display correctly? The screwup itself
suggests semicolons can appear in multi-column listboxes.
invoice number and the second column displays the (text) description. The
user types some text into a textbox, clicks Search, and the matching results
display in the listbox. Recently a record was added where the description
contained a semicolon. The description text beyond the semicolon does not
appear in the listbox. Subsequent records display... oddly. For example,
Table1
001 | Apple
002 | Banana; Cantelope
003 | Date
Listbox1
001 | Apple
002 | Banana;003;
Any suggestions on how to make this display correctly? The screwup itself
suggests semicolons can appear in multi-column listboxes.