Can the form lenght in Access only be 56 cm long at most?

[Guest]

I am working on an Access 2002 DB using Pages on the form (so they can PgDwn
and PgUp easily). I seem to be only able to make the entire length of the
form 56 cm long, and am having trouble breaking the form into pages. Any tips?

 

[Douglas J Steele]

Yes, that's a physical limit that can't be changed.

You could consider using a Tab control, rather than having to page up and
down)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am working on an Access 2002 DB using Pages on the form (so they can PgDwn
and PgUp easily). I seem to be only able to make the entire length of the
form 56 cm long, and am having trouble breaking the form into pages. Any

tips?

 

[Guest]

Thanks - at least I can stop searching through all the books and help
screens. However the reason I did not go with Tabs is the layout of the paper
form. When entering this particular data set it's easier for them not to lift
their hands from the KB to click on a button or even to have to TAB or Enter
down to a Button to move to the next Tab (believe me otherwise I would - as
much for speed considerations). It was all working quite well until I decided
to stick the last 2 (required) fields on a page by themselves so they would
not have to TAB all the way down. That's when I found I could not make the
page longer. It seems that if the last page is shorter than the others it
sometimes attaches itself to the previous one. And if I make the pages less
than 13 cm each I get a 'bleed' up onto prevous forms (does that make
sense?). I have tried everywhere to find some definitave answers to how to
set these up with no luck. Any imput? (sorry this got longer then I expected)
Ta very much.

 

[Larry Daugherty]

Actually you can use the ampersand before the character convention to
hotkey to individual tabs.

HTH

 

[Albert D.Kallal]

When entering this particular data set it's easier for them not to lift

their hands from the KB to click on a button or even to have to TAB or
Enter
down to a Button to move to the next Tab (believe me otherwise I would -
as
much for speed considerations).

Why not just set the focus to the next tab automatically when they leave the
last field on the current screen? That way NO additional keystrokes are
needed.

On the last field of the current section, just place a very small button
(and, place a arrow head, or some other nice image on the button). Make sure
this button is in the tab order, and comes right after the last text box
control. Then when the user hits enter, or tab, you put code in the button
on-enter event to flip to the next tab, and set the focus to the top most
field. So, using tabs is a great solution, and your users will NOT have to
type any extra, or more keystrokes then they do with one big huge long and
hard to use form.. It also means that simply navigation should flip between
each tab. Further, perhaps you might just code the page up/page down keys to
flip to each tab, or even use ctrl-right arrow key, and ctrl-left arrow key
to move around.