Results 1 to 7 of 7
  1. #1
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171

    Long text data field acting as if limited


    I have a form with a data field entitled "Comments". I have set this field as "long text" but the forms will not allow any data beyond maybe 3 sentences. I don't see anything in the properties sheet that clues me in.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Perhaps in the table field you set a character limit of say 100 or so?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171
    That's what I initially thought, but the short text defaults to 255 and long text doesn't even give a "field size" option.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Sorry, forgot that.

    It is possible to bind a control to a memo/long text field but set the control property to plain text. I would expect that to override the table setting but I don't know for sure. If that's not it, then is the control is bound to a table or query, and what happens if you try to enter more than a few lines worth via the query or table? That ought to pinpoint the form as the problem if you can.

  5. #5
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171
    I'll give that a shot and let you know. Thanks!

  6. #6
    ijaz8883 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    103
    Quote Originally Posted by PATRICKPBME View Post
    I'll give that a shot and let you know. Thanks!
    Mr. PATRICKPBME I am also facing this problem. but still not find any solution. But I have tried online and with the consult of someone and found that his Office 2016 is working at this issue which is copying over 255 texts but I could not solve this problem at my office. So I have tried to do a different way. I used M.S office 2007 to resolve this issue and its working perfect for this purpose. I have installed twice offices in my PC.

  7. #7
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171
    Thanks. My confusion is that I have never had this problem in the past. Just weird.

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

Similar Threads

  1. Replies: 8
    Last Post: 01-07-2020, 12:28 PM
  2. Replies: 4
    Last Post: 11-04-2019, 06:53 PM
  3. Replies: 24
    Last Post: 03-12-2019, 08:02 PM
  4. limited data in text box
    By angie in forum Forms
    Replies: 15
    Last Post: 04-19-2017, 07:07 PM
  5. Replies: 3
    Last Post: 12-31-2013, 02:53 PM

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