memo field grows in report

  • Thread starter Thread starter maggie
  • Start date Start date
M

maggie

I have a subreport that is a memo field. If I say "can
grow", the field doubles in size on the printed report,
and one half of the now doubled size is blank and the
other half has my data in it. If I don't say "can grow",
the data doesn't show at all. "Can shrink" doesn't seem
to have any effect at all. What is happening? Thanks!
 
I think that you need to give us a bit more information. Is the memo
field the only thing in the subreport - if so, why is it in a
subreport? Is the blank area above, below, or beside the real data? Is
there any possibility that you have <CR><LF> sequences in the memo
field data that are foulfing you up?

I have a subreport that is a memo field. If I say "can
grow", the field doubles in size on the printed report,
and one half of the now doubled size is blank and the
other half has my data in it. If I don't say "can grow",
the data doesn't show at all. "Can shrink" doesn't seem
to have any effect at all. What is happening? Thanks!
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Yes, the memo field is the only thing in the subreport.
I have it that way because the query that runs the main
report does not include this table. There are 6 other
subreports on the main report, all using Master/Child
links. The blank area is above the data. I checked the
 
It really does sound as if there is/are some control characters in the
memo field pushing the real text down. I cannot think of a bad format
setting that could do this.

Yes, the memo field is the only thing in the subreport.
I have it that way because the query that runs the main
report does not include this table. There are 6 other
subreports on the main report, all using Master/Child
links. The blank area is above the data. I checked the
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Yes, a large top margin setting in the control could do this - I
didn't think of that possibility because I almost never use the margin
settings, and the defaults are zero. I don't think that an odd
textalign setting could be the problem - vertically aligning to the
bottom will pull the text down in a fixed (over)size control, but
should not cause a control to expand if it doesn't need to. Checking
it doesn't do any harm, though.

Check the textalign and margin properties of your memo field.
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top