CANGROW but doesn't!

[jflachman]

I have a report with a text box that is bound to a function. The function returns a string that contains one or several text items separated by VbCrLf's. If that text box is placed in the Page Header, the field doesn't grow to show more than the first line. If that box is placed in the report header it does grow. No changes, a simple copy and paste from one header to the other.

Any help would be appreciated, thanks. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[WildHare]

If that text box is placed in the Page Header, the field doesn't grow to show more than the first line. If that box is placed in the report header it does grow.

That's odd. It does the exact OPPOSITE for me. In my case, I'd imagine it has to do with the fact that the REPORT HEADER is produced only ONE time for each report, and the page-processing part only happens that one time, for the FIRST record in the dataset. After Access has formatted and set the REPORT header, it doesn't look at the data anymore.

Are you SURE that your text box CHANGED size in the report header, but didn't in the PAGE header?...

Jim Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com

 

[jflachman]

Absolutely positive. I just went back to verify. Using a value from the function that has 5 lines (separated by 4 VbCrLf's) the report header shows the full text. Immediately below the report header on the first page is the page header which shows only 1 line, the first. On each subsequent page, only the first line is visible.

The fields are identical. In fact, I had a blank report header and I copied the entire page header with all fields into the report header. the size, spacing between fields,height of the section, everything is identical. Just one can grow, one should but doesn't. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt