Fix Access Linked to SharePoint Rejecting More Than 255 Characters
Question details
Users are unable to enter or paste more than 255 characters into an Access database field linked to a SharePoint list.

- Product
- Microsoft Access, SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to enter lengthy text into an Access 2016 form or table that syncs with a SharePoint list.
- Observed behavior
- The linked database rejects text exceeding 255 characters, even though the SharePoint column is configured as 'Multiple lines of text' and appears as 'Long Text' in Access.
Ensure you have the necessary SharePoint permissions to modify list column settings and that no other users are currently editing the linked Access database.
Change SharePoint Column Setting to Plain Text
Enhanced Rich Text formatting in SharePoint often conflicts with Access linked tables, causing the 255-character truncation issue.
SharePoint offers two versions of rich text formatting. The 'Enhanced Rich Text' option can create compatibility barriers when synced to Microsoft Access, forcing the linked table to limit the input or treat the field as read-only. Switching the SharePoint column to 'Plain Text' or standard 'Rich Text' typically resolves the limitation.
Navigate to your SharePoint site, open the affected list, click the Settings gear icon, and select 'List Settings'.
Scroll down to the Columns section and click on the specific 'Multiple lines of text' column that is experiencing the 255-character limit.
Under 'Additional column settings', locate the text type options and change the selection from 'Enhanced rich text' to 'Plain text'.
Click 'OK' at the bottom of the page to apply the new column configuration.

Refresh Linked Tables in Access
Access relies on cached table definitions. You must refresh the linked table to recognize the updated SharePoint column settings.
Switch to WPS Office for a Seamless and Free Productivity Experience
While WPS Office does not currently offer a dedicated relational database tool like Microsoft Access, it provides exceptional alternatives for processing exported database reports and managing documents. If you regularly export SharePoint lists or Access data to spreadsheets, WPS Spreadsheet delivers complete compatibility with Microsoft formats in a lightweight, user-friendly package.
- 1. Download the Installer: Visit the official WPS Office website and click the 'Free Download' button for your operating system.
- 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions.
- 3. Open Exported Data: Launch WPS Spreadsheet to seamlessly open and analyze CSV or Excel files exported from your SharePoint lists or Access databases.

Frequently Asked Questions
Why does my Long Text field in Access suddenly have a 255-character limit?
This commonly happens when the Access table is linked to a SharePoint list column configured with 'Enhanced Rich Text'. Access struggles to parse this specific rich text format over the link, falling back to a standard 255-character Short Text limitation or making the field read-only.
How do I check if my linked Access field is marked as read-only?
Open your Access form or table in Design View, select the field in question, and open the Property Sheet. Check the 'Data' tab to see if the 'Locked' property is set to 'Yes', or verify if the underlying recordset type restricts data entry.
Do I lose my data when changing a SharePoint column from Enhanced Rich Text to Plain Text?
Changing the column to Plain Text will strip any existing HTML formatting (like bolding, italics, or colors) from the text stored in that column, but the raw text characters themselves will remain intact.
Is there a way to keep rich text formatting without the 255-character limit?
You can try changing the SharePoint column setting from 'Enhanced rich text' to standard 'Rich text'. Often, Access handles standard rich text better, preserving both the formatting and the ability to exceed 255 characters.




