Results 1 to 5 of 5
  1. #1
    forrestapi is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    39

    Form based on query limiting size of a memo field

    This is my first post on here so i will try and be as descriptive as possible. I tried searching, but to no avail. The Problem is:



    I have a form that is based on a query. In that query one of the fields that i am pulling is a memo field off a table. When i run the query it limits this feild to 255 characters (the size of a standard txt field and not what the memo field should be). I did a small test form just based off the table im pulling that info from and it allowed the full amount of characters to be displayed. i looked in the properties of the query itself to see if i could find something to designate it as a memo field but couldn't. Any ideas on what i can do to rectify this situation. Thanks in advance!

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    see if you have any of the listed causes for truncation from this link.

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

  3. #3
    forrestapi is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    39
    Thanks for the link, very helpful. I found i was having this error due to Aggregation. I fixed it with the suggestion provided and it worked perfectly. Thanks again!

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    np. Please mark the thread solved so others may find it useful. Thanks.

  5. #5
    forrestapi is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    39
    Gladly, this is a great forum here, im sure i will be around here alot.

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

Similar Threads

  1. Replies: 2
    Last Post: 07-26-2010, 11:28 AM
  2. Expanding Memo Field in Form
    By AKQTS in forum Forms
    Replies: 3
    Last Post: 07-26-2010, 08:51 AM
  3. Replies: 1
    Last Post: 11-10-2009, 03:20 PM
  4. Memo field in form
    By swotr in forum Forms
    Replies: 1
    Last Post: 03-28-2009, 03:56 PM
  5. Adjusting Form size based on screen resolution
    By stombiztalker in forum Forms
    Replies: 0
    Last Post: 02-17-2009, 07:18 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