format orphan control in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How's everyone doing? Smiles all around?
I have a problem with a text box that is in the details section of my form
layout. Several of my text boxes are set for Can Grow and Can Shrink but this
causes another text box to be seperated from its label since the label is
located above the text box. I have only the form header and footer enabled. I
have used this coding in my reports:
Dim R As Report
Set R = Me

If R.Top > (7.5 * 1440) Then
R.PrintSection = False
R.MoveLayout = True
R.NextRecord = False
End If
but I also had several headers that I could fit the code into. Can I use a
version of this code in my form? I'm open to any other methods or
suggestions, provided that there isn't too much coding to do.
Thanks
 
J@50N-5ALTR said:
How's everyone doing? Smiles all around?
I have a problem with a text box that is in the details section of my form
layout. Several of my text boxes are set for Can Grow and Can Shrink but this
causes another text box to be seperated from its label since the label is
located above the text box. I have only the form header and footer enabled. I
have used this coding in my reports:
Dim R As Report
Set R = Me

If R.Top > (7.5 * 1440) Then
R.PrintSection = False
R.MoveLayout = True
R.NextRecord = False
End If
but I also had several headers that I could fit the code into. Can I use a
version of this code in my form? I'm open to any other methods or
suggestions, provided that there isn't too much coding to do.
Click to expand...


This is very confusing. On the one hand, you posted to a
forms group and said form in the body. Besides, printing a
form is not a good idea because of the limited features
provided for printing forms.

On the other hand the properties you manipulated in a report
do not exist for a form, so I have no idea how that should
relate to anything.

I don't know if it will help, but if the bottom of a CanGrow
control is lower than the top of another control, it can not
push the other control down the page.

If you really are talking about printing a form, I strongly
recommend that you reconsider using a report instead.
 
Marshall Barton said:
This is very confusing. On the one hand, you posted to a
forms group and said form in the body. Besides, printing a
form is not a good idea because of the limited features
provided for printing forms.

On the other hand the properties you manipulated in a report
do not exist for a form, so I have no idea how that should
relate to anything.

I don't know if it will help, but if the bottom of a CanGrow
control is lower than the top of another control, it can not
push the other control down the page.

If you really are talking about printing a form, I strongly
recommend that you reconsider using a report instead.
Click to expand...
Marshall, I was a tad mixed up when I was asking about forms, since the
report that I designed is intended to look like the form that the data is
drawn from. I wish to force a text box with its label to the next printed
report page so that they don't seperate when a growing text box above them
expands enough to continue the report on another page. I hope that I asked
that without much confusion. Sometimes what I ask doesn't fit with what makes
sense. Sorry.
Thanks for replying so soon.
 
J@50N-5ALTR said:
Marshall, I was a tad mixed up when I was asking about forms, since the
report that I designed is intended to look like the form that the data is
drawn from. I wish to force a text box with its label to the next printed
report page so that they don't seperate when a growing text box above them
expands enough to continue the report on another page.
Click to expand...


If you want the label push down along with its text box,
then the top of the label must be below the bottom Of the
CanGrow text box. This may(?) not be too bad since you can
squeeze up the CanGrow text box so it's design height is
very small.
 
Back
Top