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

- 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.
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.
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.
In SharePoint, open the task list, select Settings, and go to List settings. Under Columns, select Description.
In the column settings, change the text type from Enhanced Rich Text to Plain Text or Rich Text, if available, and save the change.
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.
Open the linked table in Access and try entering or editing text in the Description field.

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.

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.




