fixed form size

[susan]

I have created a Form with Various Sub forms. One of my Subforms is an Item
form where Multiple Items can be bought. I have designed the page so when 9
items are captured it is just exactly the right size and all my other
subforms are placed specifically in the correct position for this. My problem
is this. I need the form (When printed To look exactly the same everytime,
But Now it doesn;t. When I have less tha 9 items on the Order it
automatically shrinks that Specific Subform smaller messing up the position
of all the rest. It still shows me what I need to see but now my lines are
not straight any more because some lines in my other subforms overlaps with
this one etc... I have treid the Can grow and Can shrink properties , but it
is not helping. Pls help

 

[BruceM]

Reports are best for printing. Save the form as a report. Set the
subreports to whatever size they need to be. Assure that the subreport
controls have the Can Grow and Can Shrink properties set to No. Do the same
for the Detail sections in the subreports.
What happens if there are 10 items?

 

[Jeff Boyce]

Susan

If you are trying to print your form, that may be why there's a problem.

I believe you will find you have better control over layout if you use a
report. Besides, forms are for displaying data on the screen, reports are
for printing data on a page.

Or have I misunderstood?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[susan]

Thanks for both of you. It helped

Susan

If you are trying to print your form, that may be why there's a problem.

I believe you will find you have better control over layout if you use a
report. Besides, forms are for displaying data on the screen, reports are
for printing data on a page.

Or have I misunderstood?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/