Label and Textbox are being put on different pages

[cowboy]

I have a report and I have a variable subform above so I cant just put in a page break because the size of the subreport changes. How do I keep my Label for my text box on the same page as my text box?



I did some googling and read about the group keep together, but that didnt seem to work.

Any help is appreciated thanks.

[June7]

Why are they separate? Label is not associated with textbox? Is the label in Header and textbox is in Detail?

[cowboy]

The label is associated with the textbox and both are in the detail section. The text box is about 6 lines and the label is the header to that section.

[cowboy]

I have attached a new blank database I tried this on and it still does it. Here it is if you can fix it please let me know how.

[June7]

Exactly which label and textbox are the issue? The report width is too wide for 8.5" paper and the overall length exceeds one page. Otherwise, the report displays fine. Print Preview errors on the Detail section format procedure. Why are you trying to set value of a bound control? Can't do that with a report.

[cowboy]

I actually posted the wrong database, here is the blank one.

Although the one I posted has what I am finally going for, there is a sub report above the guarantee and change order information that will be different sizes for different bids so it will push the text boxes down, if the textbox goes to the next page and the header stays it looks sloppy.

[June7]

Suggestions:

1. Move the label/textbox so the bottom of text box is above the 9.5" line.

2. Move the label/textbox so the top of label is below the 9.5" line

[cowboy]

Thats not going to work if there is a subform above the text box that will be different sizes for each record.

[June7]

I never had to deal with this issue so don't really know how to fix. Would have to work with your project to explore possibilities.

[cowboy]

I found a link to someone who had the same problem in 2001, there are a few suggestions but it doesnt look like they found an answer at that time.
http://windowssecrets.com/forums/sho...-(Access-2000)

[cowboy]

I figured out a way to do it, its not pretty but it works for anyone who comes across this thread.
Add an option group, click cancel when it asks you what options you want, select the title and delete it, set border property to transparent. Then just put one around the items you want to stay together. In my case I had 3 textboxs that I wanted each to just stay with their label so I made 3 separate option groups.