G'day,

I am populating a list box with data from a database using this ...

VB Code:
  1. List1.Item(X).AddItem .Fields!JobNumber _
  2.                                   & vbTab & .Fields!TimeAvailable _
  3.                                   & vbTab & Left(.Fields!Couriertype, 2) _
  4.                                   & vbCrLf _
  5.                                   & vbTab & FromRs.Fields!CName _
  6.                                   & vbTab & FromRs.Fields!AddrSuburb _
  7.                                   & vbTab & ToRs.Fields!CName _
  8.                                   & vbTab & ToRs.Fields!AddrSuburb _
  9.                                   & vbCrLf _
  10.                                   & vbTab & TempString
, but the vbCrLf doesn't work - it just gives me 2 vertical bars.

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