Problems getting report to recognise a line feed in text field

[reglarh]

I have imported Excel data into an Access table and the text fields come over as short text. One field contains chr(10) to separate two names. An Access report does not respond and the two names are concatenated. If I use MsgBox to display this field it displays correctly on two lines. The format of the field with the report is plaintext and I cannot change this to rich text. I am of of other ideas!

 

[theDBguy]

Normally, Access uses Chr(13) & Chr(10) to create two lines. Can you add the missing character?

 

[Gasman]

Use Replace() to replace Chr(10) with vbCRLF ?