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!