Text box problems

[COV MarshallT]

I am actually having two separate issues with text boxes, and am hoping it's
not because I've got a corrupted file:
1) I have a report with text boxes that are vertically stacked, one above
the other, and the text boxes are touching but not overlapping each other.
For each of the text boxes, the "Can Grow" property is set to Yes (as well
"Can Shrink"). However, when publishing the report, whenever a text box
grows, the text box immediately below it does not move downward accordingly.
This results in the text from the upper and lower text boxes overlapping each
other. This does not happen in stacked text boxes that I have created in
reports in the past. Any suggestions on how to remedy this problem?
2) A separate problem is that in a certain report, the text in some text
boxes is cutting off after a certain number of characters (it seems to be
approximately 216). Again, the "Can Grow" property is set to yes. And
again, in other reports that I have created in the past, this didn't seem to
be a problem.

Any help you might be able to offer would be GREATLY appreciated!!

 

[Rick Brandt]

I am actually having two separate issues with text boxes, and am
hoping it's not because I've got a corrupted file:
1) I have a report with text boxes that are vertically stacked, one
above the other, and the text boxes are touching but not overlapping
each other. For each of the text boxes, the "Can Grow" property is
set to Yes (as well "Can Shrink"). However, when publishing the
report, whenever a text box grows, the text box immediately below it
does not move downward accordingly. This results in the text from the
upper and lower text boxes overlapping each other. This does not
happen in stacked text boxes that I have created in reports in the
past. Any suggestions on how to remedy this problem? 2)

They cannot be touching. Or at least the bottom of each box must not extend
beyond the top of the box below it. The gap is what causes the lower control to
be pushed down the page.

A separate
problem is that in a certain report, the text in some text boxes is
cutting off after a certain number of characters (it seems to be
approximately 216). Again, the "Can Grow" property is set to yes.
And again, in other reports that I have created in the past, this
didn't seem to be a problem.

Memo field perhaps? If so you cannot group on it or apply any formatting.
Doing so truncates the text at 255 characters.

 

[COV MarshallT]

Thank you Rick, looks like you're spot on with each of your answers. I
really appreciate your help!

 

[COV MarshallT]

Rick, now that I look into this a little further, I notice that I have other
reports with text boxes based on memo fields that are not limiting the text
displayed to 255 characters. Would you be able to clarify further what you
mean by "you cannot group on it or apply any formatting. Doing so truncates
the text at 255 characters"? It doesn't appear that I'm grouping on the
field in the other reports, and don't have any formatting that's any
different from the report I'm having trouble with. Please let me know if
there's a simple way to work around this 255 character limit with memo
fields. Thanks again for your help!

 

[Rick Brandt]

Rick, now that I look into this a little further, I notice that I have other
reports with text boxes based on memo fields that are not limiting the text
displayed to 255 characters. Would you be able to clarify further what you
mean by "you cannot group on it or apply any formatting. Doing so truncates
the text at 255 characters"? It doesn't appear that I'm grouping on the
field in the other reports, and don't have any formatting that's any
different from the report I'm having trouble with. Please let me know if
there's a simple way to work around this 255 character limit with memo
fields. Thanks again for your help!

This can happen in the report or in the query the report is bound to so step one
is to see if the text is truncated in the query.

In the query you cannot use GroupBy or Sort on the memo field and you cannot use
any format property on the memo field. You also cannot use DISTINCT (Unique
Values = Yes) in the query. The query cannot be a UNION query.

If the text is NOT truncated in the query then you have to check the report. In
the Sorting and Grouping dialog you cannot use the memo field. On the TextBox
for the memo field you cannot have a format property.

I might have missed a few things, but that's what occurs to me off-hand.

 

[COV MarshallT]

Rick, thanks again very much for your help. Based on the info you provided,
I've fixed both problems in my reports! Very much appreciated!