SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So I have an Access database where I have re-created the tables as SharePoint lists, and then use the MS Access linked table manager to connect. Everything is fine as it should be, only when I go to save data from a form in access, everything saves except memo/multiple lines of text. I get no errors, but when i open up the table (linked table now) those fields are uneditable, while the rest I can change fine?

I made the columns in sharepoint not required, and plain text? Am I missing something simple here?

share|improve this question
up vote 0 down vote accepted

found the answer to this question. I was trying to update multiple lines of text from access memo field with DAO VBA code, and the fields were set to rich text.

Once I change to plain worked fine!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.