Question Locked

Transfer of data from Access to Excel gives me visible CRLF characters

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
If I create a new line in an Access Text Box and transfer the data to excel, it shows a special character (a box) and then goes to the new line. How do I get rid of the box?

2 replies

by Former member

I am having this same issue, except in the reverse. If I try to import from Excel into Access, it is replacing my hard returns/new lines with the square symbol (CRLF characters). I too would love to know if there is a function/code that would prevent this from occurring. ~~Kandy, Summerville, SC

This discussion is closed to new replies.