Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 97 memo field (Access 97)

    Yes, it's an old version, but I work for the Gov't! <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    We have a small database that uses a memo field for "narrative". However, we recently hired a short-story author to work in that office and discovered that the field truncates to 255 when you save the record. I have checked the input form, and the table to verify it's setup properly and I can see nothing that would cause this. Upgrading to Access 2000 IS an option, but it would be "fun" since most of the other home-grown Access applications don't run nicely in Acc2K (macros and VB scripting import problems, from what I hear)

    Thanks for any info that can be passed my way. I appreciate any inputs, even if it involved thermite! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access 97 memo field (Access 97)

    Do you have something in the Format property of the memo field (either in the table, or in a text box on the form used to enter the data)? See ACC: Formatted Memo Truncates Data at 255 Characters.

  3. #3
    New Lounger
    Join Date
    May 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 memo field (Access 97)

    As a matter of fact, we do have something in the format section on the input form.. a ">" to convert to all caps. It can't be THAT easy, can it?

    I searched TechNet before posting this message, but didn't find that article. Thanks!!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access 97 memo field (Access 97)

    The > counts as formatting, so it truncates the memo field to 255 characters - it is exactly the example that the MSKB article mentions.

Posting Permissions

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