I am linking to a MySQL database. For some reason, my Access database is not recognizing carriage returns from my database. Is there anyway to change a setting so Access recognizes these?
I am linking to a MySQL database. For some reason, my Access database is not recognizing carriage returns from my database. Is there anyway to change a setting so Access recognizes these?
The carriage return in MySQL is '\n'; Access uses '\r\n', you need to convert it before display it in Access.