Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

piovesan (TechnicalUser) (OP)
13 Nov 09 14:51
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 (Programmer)
13 Nov 09 20:11
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 (TechnicalUser) (OP)
17 Nov 09 10:29
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 (Programmer)
17 Nov 09 10:58
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 (TechnicalUser) (OP)
17 Nov 09 11:26
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 (Programmer)
17 Nov 09 11:54
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 (Programmer)
17 Nov 09 12:26
You have "GROUP BY" in [LandParcel Reviews Report Query]

Duane
Hook'D on Access
MS Access MVP

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close