Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Question Unanswered: Long Text Only Giving 255 characters

    Hello,

    I have a long text box on my form. It's populated when a choice from a combo box is selected. Unfortunately, it's only returning 255 characters and tunicates the rest. I have it set to rich text, and can grow. Am I missing something? The table is also set to long text. I have searched and found issues, but no resolutions on the web. Any help is appreciated!

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    A text box should be able to enter > 255 if bound to a memo box.
    When you query a memo field, you will only get 255 characters. (thanks Microsoft)
    But you can export from the table and get all the text.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    And just to clarify, 'Long Text' is what the Wizards of Redmond now call what have been, since the beginning, Memo Fields! Why they feel the need to change things as basic as the names of Datatypes I have no idea!

    Allen Browne explains the phenomena of Memo Field truncation here:

    http://allenbrowne.com/ser-63.html

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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