Results 1 to 5 of 5
  1. #1
    Niko is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    47

    How to display whole chunks of remarks in report

    Hello everyone, I would like to display all my remarks in my report but looks like there is some limited that's why it cut off some of my remarks. What can i do so that i am able to display the whole remarks? Based on the image that i have attached it show clearly that it only display half of my remarks.


    image of my remarks that is display in the report.
    Click image for larger version. 

Name:	Untitled.jpg 
Views:	10 
Size:	18.7 KB 
ID:	30659

    My remarks:
    1) Please State: Please State:
    2) Shrink: Shrink:
    3) Weight: Weight:
    4) Weight Tolerance :Weight Tolerance :
    5) Buy: Buy:
    6) Pack:Pack:
    2) Shrink:
    3) Weight:
    4) Weight Tolerance :
    5) Buy:
    6) Pack:1) Please State:
    2) Shrink:
    3) Weight:
    4) Weight Tolerance :
    5) Buy:
    6) Pack:

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    are the remarks stored in LONG TEXT field?
    set the report field to CAN GROW = TRUE.

    side note:
    an old access bug, In queries, access only shows 255 chars. (thanks a lot microsoft) I thought they would have fixed this in newer versions but I havent checked.

  3. #3
    Niko is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    47
    Hi, yes the remarks are stored in long text field and i have set the remarks in the report field "CAN GROW = TRUE". But still it does not show all my remarks

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    then the bug still exists.
    see if you can report straight from the table (no query)... does the field show all the data?
    if so , try a query that writes to a 'report' table. Then see if the text is lost. (microsoft bastards)

  5. #5
    Niko is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    47
    Quote Originally Posted by ranman256 View Post
    then the bug still exists.
    see if you can report straight from the table (no query)... does the field show all the data?
    if so , try a query that writes to a 'report' table. Then see if the text is lost. (microsoft bastards)
    Thankyou! It works when my report is straight from the table! But why does it not show all my remarks in query? Or is there other way to show all my remarks by using query to do a report?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 03-11-2013, 05:11 PM
  2. I need a report to display the top 10
    By cdell7up in forum Reports
    Replies: 4
    Last Post: 08-16-2012, 07:14 AM
  3. display report
    By gor in forum Access
    Replies: 3
    Last Post: 07-07-2012, 02:43 AM
  4. Splitting a table into chunks
    By TheShabz in forum Queries
    Replies: 3
    Last Post: 02-18-2010, 01:32 PM
  5. Report control of a field display/no display
    By systems013 in forum Reports
    Replies: 5
    Last Post: 02-01-2010, 09:44 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums