"Can Grow" does not seem to work.....

[piovesan]

Hi....... I have a field in a report which is a memo field and I have the "can grow" option on but on the report it still seems to limit how much of that field I am seeing.... (it's not displaying all the text that is in the field on the report). Any ideas why??
Thanks!

 

[dhookom]

Does the entire field value display in the report recordsource's datasheet view?
Is the text box in a group header or footer section?
Does the text box have anything in its Format property?


Duane
Hook'D on Access
MS Access MVP

 

[piovesan]

Hi Duane! You asked:
1. Does the entire field value display in the report recordsource's datasheet view?
NO - Even in the report datasheet view the text gets cut short.........

2. Is the text box in a group header or footer section?
NO - I have a group header but this text box is not located in there........

3. Does the text box have anything in its Format property?
NO

Thanks......

 

[dhookom]

If the datasheet view truncates the field then it will not magically display more text in the report.

There are a number of causes for the truncation in the query. This is mostly caused by the query containing phrases like "DISTINCT" or "GROUP BY". If you reply with the SQL view, someone can probably point out the issue.

Duane
Hook'D on Access
MS Access MVP

 

[piovesan]

OK........ I took the DISTINCT out of there because I did have that, but it is still cutting off a portion of my text from that field...... here is my report query, and the subquery.......
The Query the report is based on is as follows:

SELECT [LandParcel Reviews Report Query].*, SDEADM_LND_CIVIC_ADDRESS.CIV_NUM, SDEADM_LND_CIVIC_ADDRESS.STR_NAME, SDEADM_LND_CIVIC_ADDRESS.STR_TYPE, SDEADM_LND_CIVIC_ADDRESS.GSA_NAME, Civic_Dec08.CIVIC, Civic_Dec08.STREET, Civic_Dec08.ST_TYPE, Civic_Dec08.COMMUNITY, [LandParcel Reviews Report Query].ID
FROM ([LandParcel Reviews Report Query] LEFT JOIN SDEADM_LND_CIVIC_ADDRESS ON [LandParcel Reviews Report Query].MaxOfCIV_ID = SDEADM_LND_CIVIC_ADDRESS.CIV_ID) LEFT JOIN Civic_Dec08 ON [LandParcel Reviews Report Query].MaxOfCIV_ID1 = Civic_Dec08.CIVIC_ID;

The subquery (LandParcel Reviews Report Query) is as follows:
SELECT SDEADM_LND_PR_REVIEW_YN.REV_DISP, SDEADM_LND_PR_REVIEW_YN.REV_ACQ, SDEADM_LND_PR_REVIEW_COMMENTS.REV_DATE, SDEADM_LND_PR_REVIEW_COMMENTS.BUS_UNIT, SDEADM_LND_PR_REVIEW_YN.ASSET_ID, SDEADM_LND_PR_REVIEW_COMMENTS.ASSET_TYPE, SDEADM_LND_PR_REVIEW_COMMENTS.RETAIN, SDEADM_LND_PR_REVIEW_COMMENTS.ACQUIRE, SDEADM_LND_PR_REVIEW_COMMENTS.RV_SURPLUS, SDEADM_LND_PR_REVIEW_COMMENTS.REV_COMMENT, SDEADM_LND_PR_REVIEW_YN.PID, SDEADM_LND_PR_REVIEW_YN.PROJ_DATE, SDEADM_LND_PR_REVIEW_YN.RE_NOTES, Max(SDEADM_LND_CIVIC_ADDRESS.CIV_ID) AS MaxOfCIV_ID, SDEADM_LND_HRM_PARCEL_MULTI.PID, Max(SDEADM_LND_CIVIC_ADDRESS_1.CIV_ID) AS MaxOfCIV_ID1, SDEADM_LND_PR_REVIEW_YN.ID, SDEADM_LND_PR_REVIEW_COMMENTS.COMMENT_ID
FROM ((SDEADM_LND_PR_REVIEW_YN LEFT JOIN SDEADM_LND_PR_REVIEW_COMMENTS ON SDEADM_LND_PR_REVIEW_YN.ID = SDEADM_LND_PR_REVIEW_COMMENTS.ID) LEFT JOIN SDEADM_LND_CIVIC_ADDRESS ON SDEADM_LND_PR_REVIEW_YN.PID = SDEADM_LND_CIVIC_ADDRESS.PID) LEFT JOIN (SDEADM_LND_HRM_PARCEL_MULTI LEFT JOIN SDEADM_LND_CIVIC_ADDRESS AS SDEADM_LND_CIVIC_ADDRESS_1 ON SDEADM_LND_HRM_PARCEL_MULTI.PID = SDEADM_LND_CIVIC_ADDRESS_1.PID) ON SDEADM_LND_PR_REVIEW_YN.ASSET_ID = SDEADM_LND_HRM_PARCEL_MULTI.ASSET_ID
GROUP BY SDEADM_LND_PR_REVIEW_YN.REV_DISP, SDEADM_LND_PR_REVIEW_YN.REV_ACQ, SDEADM_LND_PR_REVIEW_COMMENTS.REV_DATE, SDEADM_LND_PR_REVIEW_COMMENTS.BUS_UNIT, SDEADM_LND_PR_REVIEW_YN.ASSET_ID, SDEADM_LND_PR_REVIEW_COMMENTS.ASSET_TYPE, SDEADM_LND_PR_REVIEW_COMMENTS.RETAIN, SDEADM_LND_PR_REVIEW_COMMENTS.ACQUIRE, SDEADM_LND_PR_REVIEW_COMMENTS.RV_SURPLUS, SDEADM_LND_PR_REVIEW_COMMENTS.REV_COMMENT, SDEADM_LND_PR_REVIEW_YN.PID, SDEADM_LND_PR_REVIEW_YN.PROJ_DATE, SDEADM_LND_PR_REVIEW_YN.RE_NOTES, SDEADM_LND_HRM_PARCEL_MULTI.PID, SDEADM_LND_PR_REVIEW_YN.ID, SDEADM_LND_PR_REVIEW_COMMENTS.COMMENT_ID
HAVING (((SDEADM_LND_PR_REVIEW_YN.ASSET_ID)=[ Enter Asset ID])) OR (((SDEADM_LND_PR_REVIEW_YN.PID)=[ Enter PID]));

Thanks!

 

[MichaelRed]

Grow / shrink is co-dependent on the placement & formatting of other controls in hte section. Please review the ubiquitus HELP system (aka F1) and / or other references.




MichaelRed

 

[dhookom]

You have "GROUP BY" in [LandParcel Reviews Report Query]

Duane
Hook'D on Access
MS Access MVP