You want the CHARs in the other order.

Put 'text' + CHAR(13) + CHAR(10)+ ' text'

Do you have any bit fields in your SQL Table? SQL can handle nullable bit fields. Access can't however and will throw up a 3197 error whenever you try to...