Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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 text....it worked fine!

share|improve this answer

Your Answer

 
discard

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.