Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    45

    Unanswered: A string can be at most 65534

    Hi
    I have a report that lists a text field in multiple lines. This column on the report to only list 65 characters per line, and then I need count the number of lines printed for each ID. However it shows the number of lines but when i click on the show next page or show last page I get a message stating "A string can be at most 65534". Any ideas?

    Thanks

  2. #2
    Join Date
    Oct 2005
    Posts
    178
    Use Trim() function on the fields, there might some records on the following page that contains field data with lots of spaces or tabs. As alternate change variable type to long integer to accomodate longer string data.

  3. #3
    Join Date
    Nov 2005
    Posts
    2
    First of all the text field should be variable length character datatype, or that the max. length for text is 65534. You can also check the text' property to 'Can Grow' option. You can also check the report layout, if its in portrait layout then make sure that its in landscape layout.

Posting Permissions

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