I wrote a program that reads the cells of Word (2007) tables and puts the results into a database. Currently using Access 2007 memo fields. Everything is fine except that the carriage returns and line breaks don't carry over into the database. for some reason they are stripped so the resulting text is one long string. even a blank line in the text gets stripped out when it goes into the database.
.NET ProgrammingMicrosoft OfficeMicrosoft Access
Last Comment
RBECKMN
8/22/2022 - Mon
Jeffrey Coachman
Make sure the "Text Format" property (Not to be confused with the "Format" property) of the memo field is set to "Rich Text"
Can you give us some insight into your "Program" and how it inserts the text into the field?
If setting the Text Format to Rich text does not work, then another option would be to insert the text via SQL Inserts.
Something roughly like this:
CurrentDb.Execute "INSERT INTO Yourtable (YourMemoField) VALUES ('SomeText1' & '<br>' & 'SomeText2')", dbFailOnError
...With your "Program" converting whatever character the cr/lf is in Word, ...to <br> for Rich Text (HTML)
Can you give us some insight into your "Program" and how it inserts the text into the field?
If setting the Text Format to Rich text does not work, then another option would be to insert the text via SQL Inserts.
Something roughly like this:
CurrentDb.Execute "INSERT INTO Yourtable (YourMemoField) VALUES ('SomeText1' & '<br>' & 'SomeText2')", dbFailOnError
...With your "Program" converting whatever character the cr/lf is in Word, ...to <br> for Rich Text (HTML)
JeffCoachman