Results 1 to 2 of 2
  1. #1
    warrenk is offline Novice
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    3

    MySQL Linked Tables - Carriage Return

    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?

  2. #2
    Matrix's Avatar
    Matrix is offline Admin
    Windows XP Access 2003
    Join Date
    Jan 2005
    Posts
    517
    The carriage return in MySQL is '\n'; Access uses '\r\n', you need to convert it before display it in Access.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with Linked Tables
    By softspoken in forum Forms
    Replies: 22
    Last Post: 03-25-2010, 09:35 AM
  2. Importing html data - Carriage Return Problem
    By MichelleNZ in forum Import/Export Data
    Replies: 1
    Last Post: 11-26-2009, 05:13 PM
  3. Linked tables and copy
    By TimG in forum Access
    Replies: 2
    Last Post: 10-08-2009, 07:54 AM
  4. help with linked tables
    By davidoakley in forum Access
    Replies: 9
    Last Post: 06-17-2009, 05:23 PM
  5. How to force carriage return between strings?
    By Divardo in forum Reports
    Replies: 1
    Last Post: 05-21-2009, 10:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums