memo field

[Guest]

Hi

i am using vb to add a new record to a table using data from other table.
when i try to add data from several text fields to a memo field including
carriage returns and line feeds i end up with hiorizontal bars where the
return and line feeds should be.

the line of vb is as follows:

!SupplierNote = !SupplierNote & Chr(10) & Chr(13) & "Fabric Specifications:"
& Chr(10) & Chr(13) & rst1a!FabricNote & Chr(10) & Chr(13) & Chr(10) &
Chr(13) & "Label Specifications:" & Chr(10) & Chr(13) & rst1a!LabelNote &
Chr(10) & Chr(13) & Chr(10) & Chr(13) & "Garment Specifications: " & Chr(10)
& Chr(13) & rst1a!GarmentNote

where

strSQL1a = "SELECT * FROM Styles WHERE StyleID = " & rst!StyleID
Set rst1a = CurrentDb.OpenRecordset(strSQL1a)

when the data is sent to a report the bars appear as boxes

any thoughts

thanks

 

[Steve Schapel]

David,

The Chr(13) should come before the Chr(10).