J
JetGuy
Hello--
I would appreciate some advice on general technique for dynamically building
a text document or report from stored paragraphs. The paragraphs would be
included or excluded based on user input values from an Access form.
My first thought was to store the paragraphs in separate fields of a
PARAGRAPH table, then select the appropriate paragraphs into a single memo
field with VBA, then mailmerge the memo field into a Word document. An
alternative would be to create an Access report with the merged memo field as
the detail section, but I am not sure how I would manage spacing, formatting,
and editing issues.
The challenge is that the user may need to add further rich text formatting
or embellish wording.... Past experience and ideas are appreciated!
Thanks!
JetGuy
I would appreciate some advice on general technique for dynamically building
a text document or report from stored paragraphs. The paragraphs would be
included or excluded based on user input values from an Access form.
My first thought was to store the paragraphs in separate fields of a
PARAGRAPH table, then select the appropriate paragraphs into a single memo
field with VBA, then mailmerge the memo field into a Word document. An
alternative would be to create an Access report with the merged memo field as
the detail section, but I am not sure how I would manage spacing, formatting,
and editing issues.
The challenge is that the user may need to add further rich text formatting
or embellish wording.... Past experience and ideas are appreciated!
Thanks!
JetGuy