Design/Printing long forms

[Pete]

I have a form that is longer than the 22" constraint
Access allows. I have inserted a tab control so that I
can access the entire form from the same record page,
however I can't get it to print the information on the
second page of the tab control. Any ideas on how to get
tab controls to print properly?

My other choice seems to be to create separate forms with
the additional form info that wouldn't fit in the 22" and
then to link them with a macro button. However, then I
ran into a problem of ensuring that the button takes me to
the next page of the same record and not a different
record. I did link the separate form pages by a common id
tag, but still seemed to have problems. Any ideas to make
this option work?

HELP!

Cheers,
Pete.

 

[Hugh O'Neill]

I have a form that is longer than the 22" constraint
Access allows. I have inserted a tab control so that I
can access the entire form from the same record page,
however I can't get it to print the information on the
second page of the tab control. Any ideas on how to get
tab controls to print properly?

My other choice seems to be to create separate forms with
the additional form info that wouldn't fit in the 22" and
then to link them with a macro button. However, then I
ran into a problem of ensuring that the button takes me to
the next page of the same record and not a different
record. I did link the separate form pages by a common id
tag, but still seemed to have problems. Any ideas to make
this option work?

HELP!

Cheers,
Pete.

Use a Report for printing stuff out. Forms are for data entry,
manipulation and viewing. Printing Forms doesn't usually produce the
results you expect because they're not designed for that.

hth

Hugh

 

[Pete]

Thanks Hugh. I figured that might be my only solution
seeing as there wasn't an intuitive/user friendly way to
accomplish what I wanted.

Pete.

 

[Hugh O'Neill]

Thanks Hugh. I figured that might be my only solution
seeing as there wasn't an intuitive/user friendly way to
accomplish what I wanted.

Pete.

Glad to help, Pete.

Hugh

 

[Kelvin Lu]

I haven't tried this, but I think it should work. I assume you are printing
through code and not the print button on the tollbar. When you print a
form, it prints what is currently on the screen, so why not issue a command
to change the focus to a different tab control then print that tab control.
Then just keep changing the focus through each tab control until they're all
printed.

Kelvin Lu