Results 1 to 4 of 4

Thread: 255 Character Limit

  1. 08-08-2007, 03:58 PM #1
    mcanada
    mcanada is offline Registered User
    Join Date
    Aug 2007
    Posts
    5

    255 Character Limit

    When using the 'text' data type in access, it appears that the max number of characters you can allow is 255.

    Is there any way you can change that limit to allow more characters?

    Thank you.
    Reply With Quote Reply With Quote
  2. 08-08-2007, 07:12 PM #2
    Allan Murphy
    Allan Murphy is offline Registered User
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    You could change the datatype to memo this has a 64K limit
    Allan
    Reply With Quote Reply With Quote
  3. 08-08-2007, 07:34 PM #3
    mcanada
    mcanada is offline Registered User
    Join Date
    Aug 2007
    Posts
    5
    How completely simple! Thank you!
    Reply With Quote Reply With Quote
  4. 09-04-2007, 05:41 AM #4
    ajdl99
    ajdl99 is offline Registered User
    Join Date
    Sep 2007
    Posts
    6
    LOL. I also wondered about the same thing and it turned out to be so simple. Thanks for the help, Alan!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules