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
