SharePoint Document Issues

Fix Access Linked to SharePoint Rejecting More Than 255 Characters

Jason MillerJason Miller Oct 15, 2026 869 views

Question details

Users are unable to enter or paste more than 255 characters into an Access database field linked to a SharePoint list.

How to Fix Access Linked to SharePoint Not Accepting More Than 255 Characters
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.
Before you start

Ensure you have the necessary SharePoint permissions to modify list column settings and that no other users are currently editing the linked Access database.

Solution 1Recommended

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.

1
Access SharePoint List Settings

Navigate to your SharePoint site, open the affected list, click the Settings gear icon, and select 'List Settings'.

2
Edit the Target Column

Scroll down to the Columns section and click on the specific 'Multiple lines of text' column that is experiencing the 255-character limit.

3
Change Text Type

Under 'Additional column settings', locate the text type options and change the selection from 'Enhanced rich text' to 'Plain text'.

4
Save Changes

Click 'OK' at the bottom of the page to apply the new column configuration.

Change SharePoint Column Setting to Plain Text
Text Entry Restored: Once the formatting constraint is removed, Access will be able to correctly parse and store strings longer than 255 characters in the linked field.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and click the 'Free Download' button for your operating system.
  2. 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions.
  3. 3. Open Exported Data: Launch WPS Spreadsheet to seamlessly open and analyze CSV or Excel files exported from your SharePoint lists or Access databases.
Highly compatible with Microsoft Office formats, including XLSX, DOCX, and PPTX.Lightweight architecture ensures smooth performance even on older devices.Completely free to use with a familiar, tabbed interface for seamless migration.Cross-platform support across Windows, macOS, Linux, iOS, and Android.
microsoft office alternative - wps office

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.