Continuous Data without blank space

[mykil]

Hi Everyone... I have created a report for Student and I want that the data in the detail section (subreport) will continuously be filled up the page without a blank if the pages of the report is more than One(1)...See attachments.. The photo1 is the first page of the report and the photo2 is the second page.. on the the first page i have this blank space which i want to filled up with the data in the second page... I don't know how to deal with this...hope you've understand my problem

Thanks in Advance Folks!!!

 

[vbaInet]

When there's no data your subreport can Shrink. Set the Can Grow and Can Shrink properties of the Subform control to Yes.

By the way, is there a subreport in that blank space? How many subreports do you have on your main report?

 

[mykil]

Thanks for the reply vbaInet.. I try to set the Can Grow and Can Shrink properties of the Subform control to Yes, But it doesn't work...

By the way, is there a subreport in that blank space? How many subreports do you have on your main report?

No, it doesn't have..my report only contains one subreport...

Pardon me for the late reply!!!

 

[vbaInet]

So where's that blank space coming from? I suspect your Page Footer section is what is causing the blank space.

 

[mykil]

I don't know vbaInet...I will attach my stripped accdb when I get back home so that you could take a look with it. if that's OK to you.

 

[vbaInet]

Yep, that's fine!

 

[mykil]

Thanks.. Ok! Here's my Stripped accdb...Type this on the parameter value required (Student ID number = 110529) of the report..Just play with my accdb..

Thanks in Advance vbaInet...

 

[vbaInet]

Why is no record coming up with that number?

 

[mykil]

Oh!!! Sorry vbaInet.. It's 1110529

 

[vbaInet]

In the main report's Detail section, set the Keep Together property to No.

Also, why are you not showing each student on a new page? On the second page of the report the next student's details begins to appear which is wrong.

 

[mykil]

Also, why are you not showing each student on a new page? On the second page of the report the next student's details begins to appear which is wrong.

Uhmm..Actually the report is only for one Student to appear every time the user wants to view the report so that if he/she wants to print it there's no need to set what page he/she wanted to print...

I have put a textbox on the page footer of the report named REMARKS that will indicate if the report has 1 or more pages... So, if the report's page is only 1 the REMARKS will be "Nothing Follows", if it has 2 or more pages, the REMARKS on the first or second page must be "Continued on next page" and on the last page the REMARKS will be "Nothing Follows"...Can you help me with this vbaInet?

 

[vbaInet]

Just check against Me.Page and Me.Pages.

And if it's for one student don't use LIKE, use = in the Record Source.

 

[mykil]

Just check against Me.Page and Me.Pages.

where could I find the me.Page and me.Pages?I'm new to it...

And if it's for one student don't use LIKE, use = in the Record Source.

How to do it vbaInet? I don't know on how to do that... Can you give me the directions.

 

[mykil]

And if it's for one student don't use LIKE, use = in the Record Source.

Found it... Looks like I'm too dependent...

 

[vbaInet]

In the Page Footer, put a textbox and set the Control Source to

=[Page] & " of " & [Pages]

In your label textbox you can do:

=IIF([Page] = [Pages], "Nothing Follows", "Continued on next page")

If I were you I will just show "Page 1 of X" only.

 

[mykil]

Thank you very much vbaInet!!!

If I were you I will just show "Page 1 of X" only.

I agree... But, they want me to do the other way, I have to follow the one who told me to make the database unless I will not get paid.

Having fun of making simple things into a complicated one!!!

 

[vbaInet]

But of course you wanna get paid

Happy to help!

 

[mykil]

That's the best thing of being a programmer even for a freshman like me..Getting paid for the job