Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    CanGrow property limited for report text controls? (97SR2)

    Most valuable members of the Lounge,
    is it possible that the 'Can Grow' property for report text controls is limited?
    I have a text box with this property enabled. It does effectively grow when the amount of text asks for it <img src=/S/smile.gif border=0 alt=smile width=15 height=15> but than apparently gets stuck at a certain height so it doesn't entirely display its content... <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>.
    Any ideas about how I can solve this problem?
    Hasse
    ps The text control displays a memo field.
    ps It's a report quite crowded by text controls & lines but I don't think that could be the reason: in that case, there assume there would be no text box growth at all...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: CanGrow property limited for report text controls? (97SR2)

    I performed a small test. I dumped the text of a 14 page Word document into a memo field, then created a report to display the memo field. The text box spread itself over 12 pages to display all text (line spacing in the report was tighter than in Word; that explains the difference in the number of pages.) So there does not seem to be an intrinsic limitation to the effective size of a text box.

    Have you made sure that the Can Grow property of the section is also set to Yes? It's not enough to set it for the text box only.

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CanGrow property limited for report text contr

    I too have had some issues with this can grow property. If viewed on screen, it always looks pretty good. However, when you output the file to something like RTF format, then things get shifted around and sonetimes the fields will get truncated. So, instead we switched to PDF output and it seems to work much better.

    Mark

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: CanGrow property limited for report text contr

    Yes, Access is uhhh let's say challenged when it comes to exporting reports to RTF. Snapshot and PDF are much better ways to produce output that can be viewed by users who don't have Access. But I assumed that Hasse's problem was that the text was truncated in Access itself; I may be wrong, though.

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: CanGrow property limited for report text controls? (97SR2)

    If the memo field is formatted, it will be truncated at 255 characters. According to MSKB Art 103998 - ACC: Formatted Memo Truncates Data at 255 Characters:

    <hr>SYMPTOMS

    When you apply formatting, such as a closing or opening angle bracket (> or <), to a field with the Memo data type, the data in the field appears truncated after the 255th character.

    CAUSE

    When you apply formatting to a Memo field, it is treated as a Text field, which has a 255-character limit. The data is not physically truncated, but only 255 characters are viewable.

    STATUS

    This behavior is by design.<hr>
    Recommend check to see if any formatting is being applied to the memo field. Other than this factor, would not know why all data in field is not displayed in report if Can Grow property is set correctly.

    HTH

  6. #6
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: CanGrow property limited for report text controls? (97SR2)

    The section's 'Can Grow' property is OK, so it must be something else...
    Unlike in msantos' situation, also the report preview shows the 'trunctated' text box 'correctly' as it is printed.
    I've included a zipped sample in attachment. The problem occurs (at least?) with the 'Notes' field (just the contents is screwed a little for privacy reasons).
    Thanks already for your reply.
    Attached Files Attached Files

  7. #7
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: CanGrow property limited for report text contr

    Memo fields can be truncated when exporting to RTF format. See this MSKB article:

    MSKB 288877 - ACC97: Memo Field That Is Exported to RTF Format May Be Truncated

    As MS says, "Microsoft has confirmed that this is a problem in Access 97." (and presumably other versions as well). Also see:

    MSKB 178743 - ACC: Exported Query Expression Truncated at 255 Characters

    MSKB 182302 - ACC97: Memo Field Truncated When Report Is Output to Microsoft Excel 97

    MSKB 92892 - ACC: Concatenation of Memo Fields Creates Text Field

    HTH

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: CanGrow property limited for report text controls? (97SR2)

    <!profile=MarkD>MarkD<!/profile> was spot on with his reply: the text box bound to Notes has a Format @. This truncates the memo field to 255 characters. If you clear the Format property, the entire memo field will be displayed.

  9. #9
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: CanGrow property limited for report text controls? (97SR2)

    Guys, I solved the problem - <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Mark for the tip. All memo fields' controls had a '@' in their format property. After removing it, truncation was gone.
    It's pretty weird though: I *never* adapted this format (consciously) to those controls. Apparently Access entered this 'format' automatically, maybe in one or another side effect of I don't know which deed of mine. I added a memo field control to the report to check whether Access enters the '@' format by default, but it didn't <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>. I guess this is one of those 'just accept it like it is' things <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.
    Thanks again!

  10. #10
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: CanGrow property limited for report text controls? (97SR2)

    Thanks, Hans! I see you were already there with the answer when I was still writing. Have a nice day...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •