Creating Form Letters

[Weekleyba]

I have a form where the user inputs data.
I then create a report based on those inputs.
The problem is, the report is a form letter and some of the fields are inside paragraphs. When the character length of the field changes, how can I force the paragraph in the report to grow or shrink around those text boxes?

e.g. (bold represents fields that would come from users inputs in the form.)

"Based on the provisions of Public Law 99 and requests from the Franklin Automated Controls Company, hereafter the Eagles Landing Estates, on the...."

Change the fields to short character lengths creates the spaces. (Had to use underscore for spaces to show up):

"Based on the provisions of Public Law 99 and requests from the ABC Company ___________________, hereafter the Sky Community ___, on the...."

Any help would be appreciated.
Thanks.

 

[Ranman256]

building internal form letters like this can be a pain. To keep the bold on some words and not others, means you must breakup paragraphs in order to get the bold words, etc.
Basically a jigsaw puzzle.
or
you can use Word mail merge which does a little better.

it may be the same amount of work for both versions.

 

[Mark_]

Something like

Me.TxtField = "Based on the provisions of Public Law 99 and requests from the "
Me.TxtField = Me.TxtField & Me.CompanyName
Me.TxtField = Me.TxtField & ", hereafter "
Me.TxtField = Me.TxtField & Me.ShortCompanyName
Me.TxtField = Me.Txtfield  & ", on the...."

Put together your paragraphs as pieces, then put the pieces together when you format the detail portion of your report.

So long as your only doing a page or two this works well. For anything extensive I'd go with Mail merge like Ranman suggests.