Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting form fields in word

Status
Not open for further replies.

RMCGAR

Mechanical
Jul 20, 2006
5
I'm trying to automate the quote sheet at my office and have come up with a nice userform with that looks nice and has some vba code and is mostly efficient. The last problem that I would like to tackle is this:
First off the form has space for company name, quote, number, date, ect. then a table with a description of the part/service and a price. There is often a need for multiple pages and the description of one part/service may be longer then the space provided on one page. My goal is to be able to link the form field on one page provided for the part/service description to the one on the next page. So say you type a description of a part/service that takes up the entire space provided for the form field (on one page) and then you decide to go back and add a sentence to the begining, i would like the spill over text to be added to the begining of the formfield on the next page. Is this possible?

I hope this description was clear enough let me know if it was not.

I'm comfortable with basic VBA programming if that is necesarry.

Thank You,
Rory
 
Replies continue below

Recommended for you

Why don't you just make the input box bigger?
 
It is hard to explain but it has to do with the layout of the form. Each page looks the same and in the middle of the page is the table with the inputs for parts and prices. The input box is already as large as it can be, as if I were to increase the size it would push another part of the form such as the box for the costumer signature onto page two, ruining the apperance. As well as messing up the format of the following pages.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor