SharePoint Document Issues

Make a SharePoint Text Field Editable in Access

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Make a SharePoint Online Multiple Lines of Text column editable in a linked Microsoft Access table.

Make a SharePoint Multiple Lines of Text Field Editable in Access
Product
SharePoint Online and Microsoft Access
Device & OS
not provided
Scenario
A user wants to edit a SharePoint task list's Description field from a linked Access table.
Observed behavior
The Description field is editable on the SharePoint website but appears read-only in Access.
Before you start

Check that you have permission to change the SharePoint list's column settings and that the Description column uses Multiple Lines of Text. Review any existing formatting before changing the text format, as formatting may be affected.

Solution 1Recommended

Change the SharePoint column's text format and refresh the Access link

Use this approach when an Enhanced Rich Text column is editable in SharePoint but read-only in Access.

1
Open the column settings

In SharePoint, open the task list, select Settings, and go to List settings. Under Columns, select Description.

2
Change the text format

In the column settings, change the text type from Enhanced Rich Text to Plain Text or Rich Text, if available, and save the change.

3
Refresh or relink the table

In Access, open External Data > Linked Table Manager, select the SharePoint-linked table, and refresh it. If the change is not reflected, delete the table link and link to the SharePoint list again through External Data.

4
Test the field

Open the linked table in Access and try entering or editing text in the Description field.

Change the SharePoint column's text format and refresh the Access link
Check formatting and available settings: Changing the text type can affect existing formatting. Available column options may vary by SharePoint interface and list configuration.
Free Microsoft Office alternative

Work with Office files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for common Office formats, making it easier to move everyday document, spreadsheet, and presentation work. It does not fix Access links to SharePoint lists.

Open and edit Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXReview exported list data in a spreadsheetUse a familiar interface for everyday Office tasksMove existing compatible files into a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can I edit the Description field in SharePoint but not in Access?

An Enhanced Rich Text setting on a Multiple Lines of Text column can cause the field to appear read-only in a linked Access table. Check the column under SharePoint List settings > Columns.

Which SharePoint text setting should I use?

In the Description column settings, change Enhanced Rich Text to Plain Text or Rich Text if available. Review existing formatting first because the change can affect it.

What should I do if Access still shows the field as read-only?

Use External Data > Linked Table Manager to refresh the linked table. If the updated setting is not reflected, delete the table link and link to the SharePoint list again.

Does changing the Access caching option fix this issue?

In the reported case, the field remained read-only regardless of the caching setting. Check the SharePoint column's text format and refresh the link instead.