G'day,
I am populating a list box with data from a database using this ...
, but the vbCrLf doesn't work - it just gives me 2 vertical bars.VB Code:
List1.Item(X).AddItem .Fields!JobNumber _ & vbTab & .Fields!TimeAvailable _ & vbTab & Left(.Fields!Couriertype, 2) _ & vbCrLf _ & vbTab & FromRs.Fields!CName _ & vbTab & FromRs.Fields!AddrSuburb _ & vbTab & ToRs.Fields!CName _ & vbTab & ToRs.Fields!AddrSuburb _ & vbCrLf _ & vbTab & TempString
I know I can use AddItem several times to simulate the line feed, but that's no good to me as clicking on one item won't select all the tiems in the record.
Peter




Reply With Quote