Page Break on Form

[PPCO]

I'm trying to use a page break on a form. I'm trying to separate fields and
have the field below the page break show up at the top of the page. I want to
be able to tab between fields, but when I do, it seems to ignore the page
break and brings the field below the page break up at the bottom of the page
(it scrolls down slightly). Thanks

 

[PPCO]

Ok, so it looks like you have to disable the ability to tab and use the pg
up/pg dwn button. Wondering though if there's a way to be able to use the tab
key instead. Thanks

 

[Maarkr]

it needs a PAGE UP or PAGE DOWN key to make it happen... i've never done it
before and many may not recommend it, but maybe a send keys - page down
command after exiting the last field on the top part of the form? but then
users may not know how to get back to the top...

 

[Arvin Meyer MVP]

Make sure that:

1. Autoresize is set to No
2. The physical saved size of the form view is 1 page.
3. The page size below the page break is the same size as the page above.

 

[Graham]

After importing a small db from excel I am trying to print labels for mail
out. Everything prints OK except that only 27 of the 30 labels are printed.
Avery 5160 2 5/8 by 1 inch, 30 to a sheet. Any suggestions, I'm using the
2007 version of access.

thanks,

Graham

 

[John W. Vinson]

After importing a small db from excel I am trying to print labels for mail
out. Everything prints OK except that only 27 of the 30 labels are printed.
Avery 5160 2 5/8 by 1 inch, 30 to a sheet. Any suggestions, I'm using the
2007 version of access.

thanks,

Graham

Not all printers allow you to print from edge to edge of the paper. If the
printed area plus the margin are too big... you're in trouble. Try reducing
any "white space" around the labels to the minimum possible, reduce margins to
cover just the "waste space" on the rim of the 5160 sheet, etc.