report reachs max length

[le888]

Hi,

I took a form which I have created and I save in the report format so, in this way I can print it out. But, my form has serveral tabs when I open the report in view mode it shows only the first tab info. What is the solution for showing all the info in my form? I have try to put the all the info into the report but the maximun length is about 53'' . What can I do?

Le888

 

[llkhoutx]

Maximum report page length is 22"", exclusive of page the header and footer.

 

[le888]

Use subreports for each of the tab pages. When you place the subreports on the main report, they do not need to be fully expanded. You can make them one row high and they will be fine. Access expands them as it builds the report pages. Just make sure that the canShrink and CanGrow properties for all controls and sections are set to Yes.

Thanks, can you provide me an example?

Le888

 

[le888]

Thanks, I found the controls and it works fine.

Le888