How do I extend the length of a form in MS-Access

geeta_m9
geeta_m9 used Ask the Experts™
on
I have created a form in MS-Access which has some large text fields. Is there a way to extend the length of the form so that I can fit more content on it and the text boxes on the form don't appear broken (see attachment). Alternatively, is there a way to have a second display screen on the form, e.g. by clicking a "next button" where I can display more content so the form has essentially "two pages".

Thanks.
Form-Length.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Architect / Systems Analyst
Top Expert 2007
Commented:
In this case, have you considered using the Tab control ?

mx

Author

Commented:
No, how would you use it?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems Analyst
Top Expert 2007

Commented:
tab control

tc
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I am not sure what it does. Will it display a grid as in the illustration?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems Analyst
Top Expert 2007

Commented:
Yes. You can add controls (including subforms) to any/all tabs.  Try one out ... open a new Form, and drag on a Tab Control.

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems Analyst
Top Expert 2007

Commented:
Basically, it's a way to 'extend' the Form - only keeping the Form a reasonable size - great when you need more real estate on the Form.  Easy to use.

mx

Author

Commented:
I tried it out and I think I will go with it. Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial