I am using Access to insert a string into a table cell in a Word using VBA.
The string is of the format: "Subject 1: text goes here & vbCrLf & Subject 2: More text goes here & vbCrLf & Subject 3: Yet more text goes here"
In the word document I would like it to appear like this:
Subject 1: text goes here
Subject 2: More text goes here
Subject 3: Yet more text goes here
I confess to not even knowing how to approach it because I need to reference specific points in the string to apply formatting rather than specific points in the word document.
Would anyone have any ideas?
The string is of the format: "Subject 1: text goes here & vbCrLf & Subject 2: More text goes here & vbCrLf & Subject 3: Yet more text goes here"
In the word document I would like it to appear like this:
Subject 1: text goes here
Subject 2: More text goes here
Subject 3: Yet more text goes here
I confess to not even knowing how to approach it because I need to reference specific points in the string to apply formatting rather than specific points in the word document.
Would anyone have any ideas?