Hello all,
I am having trouble with a form which needs to be printed on one page. This form contains subforms and one of these subforms is 2 coloumns textbox of from a table/query. The problem is that this subform is bigger than the space it has on the main form so when trying to print, we will not get all the data from the subform. (we would get a scroll bar and ...)

Now a solution would be to have the list grow horizontally (to the left rather than down... that seems to give it enough space to fit all the data... but it is not a good solution since if the amount of data grows same problem happens.)
I have tried to explain this to my best ability please help and ask questions if you don't undertand.

I tried pivot/crosstabs but to complicated... i am new to Access

thanks in advance,
Khalifeh

__________________
Sam Gharnagh
Jr. Programmer Analyst at MOH
Comp Sci at UofW

Forms are not meant to be used for printing. Create a reports instead and you will get better results. Try to open the form in design view and do a save as, then save as report and format as needed.



Sal

Thank you Sal
but I can't do what you suggested... There is no feature save as (a report) and I cannot include a report in a subform...
I do not want a report really, because there are other uses for the form so printing the form for some purposes solves my problem but since it doesnt show all the data then it is useless.
All I wanna do is present the data growing to the right rather than going down... and i dunno all the possible ways access lets u do that? Is there any list or table format i can use?

Thank you again,
Khalifeh

Sam Gharnagh
Jr. Programmer Analyst at MOH
Comp Sci at UofW