We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
vb problem reading text from Word tables
Posted on 2012-12-26
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
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)
JeffCoachman
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
Word does not records the line breaks, it records only the carriage return with one character only, Chr(13).
Access memo fields record line breaks as the more standard combination of 2 characters, Chr(13) Chr(10).
I would try something like the following:
textInBd = textInWord.Replace(Chr(10)
Access memo fields record line breaks as the more standard combination of 2 characters, Chr(13) Chr(10).
I would try something like the following:
textInBd = textInWord.Replace(Chr(10)
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
The viewer will learn how to create a slide that will launch other presentations in Microsoft PowerPoint.
In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide:
…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 1 hour left to enroll
622 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.