If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MoveLayout and line feed question
I have a report where several text items are drawn on one line, and to
prevent a line feed, Me.MoveLayout = False is used. Sometimes these text items have more text, and CanGrow is set to true so they will expand down (the width is calculated for a time line). The detail section also has CanGrow set to true. However the detail lines are always the same height and subsequent lines write over text items made longer by CanGrow. Debug.Print Me.txtName.Value & " --- " & Me.txtName.Height shows all txtName fields to be the same height, even when they have grown. How can I get the detail line to expand so that the text items don't overlap? Mich |
#2
|
|||
|
|||
MoveLayout and line feed question
I expect the text boxes are eventually printed over a group footer section
and the issue is the group footer section doesn't grow to match the tallest detail section. Is that a correct assumption? Also, you can't grab the height of a grown control until the On Print event. The On Format will always display the design height. -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: I have a report where several text items are drawn on one line, and to prevent a line feed, Me.MoveLayout = False is used. Sometimes these text items have more text, and CanGrow is set to true so they will expand down (the width is calculated for a time line). The detail section also has CanGrow set to true. However the detail lines are always the same height and subsequent lines write over text items made longer by CanGrow. Debug.Print Me.txtName.Value & " --- " & Me.txtName.Height shows all txtName fields to be the same height, even when they have grown. How can I get the detail line to expand so that the text items don't overlap? Mich |
#3
|
|||
|
|||
MoveLayout and line feed question
You were right about the On Format and On Print - I now know the height of
the taller box. My test data draws four rows of information, the third row has a CanGrow text box that is longer, but the 4th detail row covers the bottom part of it. There is no code governing the footer format - I made it smaller but it made no difference to the detail lines.. Something must be stopping the detail section from growing. ??? Mich "Duane Hookom" wrote in message ... I expect the text boxes are eventually printed over a group footer section and the issue is the group footer section doesn't grow to match the tallest detail section. Is that a correct assumption? Also, you can't grab the height of a grown control until the On Print event. The On Format will always display the design height. -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: I have a report where several text items are drawn on one line, and to prevent a line feed, Me.MoveLayout = False is used. Sometimes these text items have more text, and CanGrow is set to true so they will expand down (the width is calculated for a time line). The detail section also has CanGrow set to true. However the detail lines are always the same height and subsequent lines write over text items made longer by CanGrow. Debug.Print Me.txtName.Value & " --- " & Me.txtName.Height shows all txtName fields to be the same height, even when they have grown. How can I get the detail line to expand so that the text items don't overlap? Mich |
#4
|
|||
|
|||
MoveLayout and line feed question
I would really like to know if the contents of the detail sections is
actually being rendered in a group footer section. Change the background color of the footer section to see if that is where all of your details are being displayed. Try double the height of your group footer. What happens when you do that? -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: You were right about the On Format and On Print - I now know the height of the taller box. My test data draws four rows of information, the third row has a CanGrow text box that is longer, but the 4th detail row covers the bottom part of it. There is no code governing the footer format - I made it smaller but it made no difference to the detail lines.. Something must be stopping the detail section from growing. ??? Mich "Duane Hookom" wrote in message ... I expect the text boxes are eventually printed over a group footer section and the issue is the group footer section doesn't grow to match the tallest detail section. Is that a correct assumption? Also, you can't grab the height of a grown control until the On Print event. The On Format will always display the design height. -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: I have a report where several text items are drawn on one line, and to prevent a line feed, Me.MoveLayout = False is used. Sometimes these text items have more text, and CanGrow is set to true so they will expand down (the width is calculated for a time line). The detail section also has CanGrow set to true. However the detail lines are always the same height and subsequent lines write over text items made longer by CanGrow. Debug.Print Me.txtName.Value & " --- " & Me.txtName.Height shows all txtName fields to be the same height, even when they have grown. How can I get the detail line to expand so that the text items don't overlap? Mich |
#5
|
|||
|
|||
MoveLayout and line feed question
At first I wasn't sure what you were having me change - then realized I do
have a footer - and the MoveLayout is keeping it on the same line as the detail, but it isn't growing as expected. Looking through my notes I realized that this report is based on one in one of your databases - a calendar database with various reports showing weekly doctor appointments and rptRotation which was the basis for this report that I am having problems with when using CanGrow on a detail field. I've had this database since 2001, and needed a calendar based report which your database showed great examples of. Can you help me Grow the footer with the detail? Thanks, Mich "Duane Hookom" wrote in message ... I would really like to know if the contents of the detail sections is actually being rendered in a group footer section. Change the background color of the footer section to see if that is where all of your details are being displayed. Try double the height of your group footer. What happens when you do that? -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: You were right about the On Format and On Print - I now know the height of the taller box. My test data draws four rows of information, the third row has a CanGrow text box that is longer, but the 4th detail row covers the bottom part of it. There is no code governing the footer format - I made it smaller but it made no difference to the detail lines.. Something must be stopping the detail section from growing. ??? Mich "Duane Hookom" wrote in message ... I expect the text boxes are eventually printed over a group footer section and the issue is the group footer section doesn't grow to match the tallest detail section. Is that a correct assumption? Also, you can't grab the height of a grown control until the On Print event. The On Format will always display the design height. -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: I have a report where several text items are drawn on one line, and to prevent a line feed, Me.MoveLayout = False is used. Sometimes these text items have more text, and CanGrow is set to true so they will expand down (the width is calculated for a time line). The detail section also has CanGrow set to true. However the detail lines are always the same height and subsequent lines write over text items made longer by CanGrow. Debug.Print Me.txtName.Value & " --- " & Me.txtName.Height shows all txtName fields to be the same height, even when they have grown. How can I get the detail line to expand so that the text items don't overlap? Mich |
#6
|
|||
|
|||
MoveLayout and line feed question
I'm not sure how to grow the group footer. On solution might be to place a
text box in the group footer that is similar to growing one in the detail section. You would need to get the new text box to have the same width and control source so it would grow enough to push the bottom of the group section down. You might try set the can grow to no and then add code to adjust the font size to display the total value. -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: At first I wasn't sure what you were having me change - then realized I do have a footer - and the MoveLayout is keeping it on the same line as the detail, but it isn't growing as expected. Looking through my notes I realized that this report is based on one in one of your databases - a calendar database with various reports showing weekly doctor appointments and rptRotation which was the basis for this report that I am having problems with when using CanGrow on a detail field. I've had this database since 2001, and needed a calendar based report which your database showed great examples of. Can you help me Grow the footer with the detail? Thanks, Mich "Duane Hookom" wrote in message ... I would really like to know if the contents of the detail sections is actually being rendered in a group footer section. Change the background color of the footer section to see if that is where all of your details are being displayed. Try double the height of your group footer. What happens when you do that? -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: You were right about the On Format and On Print - I now know the height of the taller box. My test data draws four rows of information, the third row has a CanGrow text box that is longer, but the 4th detail row covers the bottom part of it. There is no code governing the footer format - I made it smaller but it made no difference to the detail lines.. Something must be stopping the detail section from growing. ??? Mich "Duane Hookom" wrote in message ... I expect the text boxes are eventually printed over a group footer section and the issue is the group footer section doesn't grow to match the tallest detail section. Is that a correct assumption? Also, you can't grab the height of a grown control until the On Print event. The On Format will always display the design height. -- Duane Hookom Microsoft Access MVP "M Skabialka" wrote: I have a report where several text items are drawn on one line, and to prevent a line feed, Me.MoveLayout = False is used. Sometimes these text items have more text, and CanGrow is set to true so they will expand down (the width is calculated for a time line). The detail section also has CanGrow set to true. However the detail lines are always the same height and subsequent lines write over text items made longer by CanGrow. Debug.Print Me.txtName.Value & " --- " & Me.txtName.Height shows all txtName fields to be the same height, even when they have grown. How can I get the detail line to expand so that the text items don't overlap? Mich |
#7
|
|||
|
|||
MoveLayout and line feed question
Hi Mich,
I don't know if this is your problem, but if any of your text items touch an adjacent text item, your text items will not grow. To eliminate the problem, leave a hair-width space between each of your text items. Steve "M Skabialka" wrote in message ... I have a report where several text items are drawn on one line, and to prevent a line feed, Me.MoveLayout = False is used. Sometimes these text items have more text, and CanGrow is set to true so they will expand down (the width is calculated for a time line). The detail section also has CanGrow set to true. However the detail lines are always the same height and subsequent lines write over text items made longer by CanGrow. Debug.Print Me.txtName.Value & " --- " & Me.txtName.Height shows all txtName fields to be the same height, even when they have grown. How can I get the detail line to expand so that the text items don't overlap? Mich |
Thread Tools | |
Display Modes | |
|
|