I know apparently what the problem is but can't seem to figure out how to fix it. Let's see if I can explain what's going on coherently.
I have a field in a table that we copy the text from an email into so they can be associated with a client. These could be many paragraphs.
All is fine when I copy right from the email in Outlook into the field in Access. The email is copied exactly as it looks.
To make my life "easier" I do multiple at a time by copying the info into Excel and the copying multiple records into the Access table at once. Saves me having to keep searching for what client the record should be attached to.
But when I do this second method the email in the Access field looks like one big long sentence. Kind of makes it difficult to read at a glance.
I copied the data out of the Access field and into word to check if the returns were still there. They were.
I'm guessing that it has something to do with when I copy it into Excel the individual lines are no longer returns but line breaks. And then Access gets confused.
Anybody come across this and know how to fix it?
If not, I'll just instead of putting them in Excel I'll put them directly in Access from now on.
Thanks
Kathie
I have a field in a table that we copy the text from an email into so they can be associated with a client. These could be many paragraphs.
All is fine when I copy right from the email in Outlook into the field in Access. The email is copied exactly as it looks.
To make my life "easier" I do multiple at a time by copying the info into Excel and the copying multiple records into the Access table at once. Saves me having to keep searching for what client the record should be attached to.
But when I do this second method the email in the Access field looks like one big long sentence. Kind of makes it difficult to read at a glance.
I copied the data out of the Access field and into word to check if the returns were still there. They were.
I'm guessing that it has something to do with when I copy it into Excel the individual lines are no longer returns but line breaks. And then Access gets confused.
Anybody come across this and know how to fix it?
If not, I'll just instead of putting them in Excel I'll put them directly in Access from now on.
Thanks
Kathie