A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

MoveLayout and line feed question



 
 
Thread Tools Display Modes
  #1  
Old August 20th, 2009, 06:20 PM posted to microsoft.public.access.reports
M Skabialka
external usenet poster
 
Posts: 570
Default 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  
Old August 20th, 2009, 06:31 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old August 20th, 2009, 06:53 PM posted to microsoft.public.access.reports
M Skabialka
external usenet poster
 
Posts: 570
Default 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  
Old August 20th, 2009, 07:11 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old August 20th, 2009, 08:32 PM posted to microsoft.public.access.reports
M Skabialka
external usenet poster
 
Posts: 570
Default 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  
Old August 20th, 2009, 09:30 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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









  #8  
Old August 21st, 2009, 02:44 PM posted to microsoft.public.access.reports
M Skabialka
external usenet poster
 
Posts: 570
Default MoveLayout and line feed question

No, Duane was right in that it's a footer thing - I'm working on that issue.

"Steve" wrote in message
...
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.