[Robbie0731]

I have a word template that has field data that is populated with data from a
SQL database. When one of the fields being populated uses multiple lines,
the entire document is advance down. This causes information from the next
pages to advance down messing up the formatting. Is there a way to lock the
text in parts of the document and only allow other parts to move? The first
page contains the data from the SQL Database and some blank space to allow
the text to move down. The second page and following pages need to remain
how they appear in the document.

Thank

[Jay Freedman]

Robbie0731 wrote:
I have a word template that has field data that is populated with
data from a SQL database. When one of the fields being populated
uses multiple lines, the entire document is advance down. This
causes information from the next pages to advance down messing up the
formatting. Is there a way to lock the text in parts of the
document and only allow other parts to move? The first page contains
the data from the SQL Database and some blank space to allow the text
to move down. The second page and following pages need to remain how
they appear in the document.

Thank

If the "blank space" at the bottom of the first page consists of empty
paragraph marks, remove it. Instead, mark the first paragraph of the second
page with the paragraph formatting "Page break before" (on the Line and Page
breaks tab of the Format Paragraph dialog).

After this change, if the information inserted from the database is long
enough to overflow the first page, it will create a new second page, and
what was the second page will become the third. As long as the data stays
within the first page, though, nothing on the second page or later will
move.

If that isn't acceptable, you can put the data field on the first page into
a table, and set the table's row height to an Exact measurement in the Table
Properties Rows dialog. Then if the data is too long, it will just not
display anything below the bottom of the table.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.