Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Jan 2005
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Amount of characters a MS ACCESS field can hold

    I built a form for clients to submit messages to me. In my MS ACCESS db the max character length accepted for a field is 255. My question is how do I let a user type as much as they want before they submit the form to me? Am I not doing something right or what should I do to get around the 255 chars maximum?

    Any help or suggestions on this would be great.

    Thanks in advance.

    Paul

  • #2
    Smokes a Lot
    Join Date
    Jul 2003
    Location
    CA, USA
    Posts
    1,594
    Thanks
    5
    Thanked 20 Times in 20 Posts
    Use the "memo" data type? I have 5000 line of text in a few of the fields in mine. I think the 255 character limit only applies to the "text" data type.


    Basscyst
    Helping to build a bigger box. - Adam Matthews

  • #3
    New Coder
    Join Date
    Jan 2005
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile

    Hey - thank you for the quick reply. I appreciate it. You know, after I posted this message I figured the silly mistake I made. See what 15 hours of pushing keys does to ones brain?

    Thanks for the reply.

    Paul2

  • #4
    Regular Coder
    Join Date
    Jul 2004
    Location
    France
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The TEXT data types

    A TEXT data type is a data type that establishes a field that can store text, or a combination of text and numbers (alphanumeric), but whose numbers are not used for calculations. Examples are phone numbers or e-mail addresses. When you create your tables through the Access user interface, you have two basic text types: TEXT and MEMO. But when you use SQL statements such as CREATE TABLE or ALTER TABLE to create your tables, you have many other synonyms of the TEXT and MEMO types to choose from.

    In general, text fields can be up to 255 characters, while memo fields can be up to 65,535 characters, but if the memo field does not contain any binary data, then its only limit is the maximum size of the database (approximately 2.14GB or 1,070,000,000 Unicode characters). In addition, unused portions of text fields are not reserved in memory.



    source = http://msdn.microsoft.com/library/de...l/acintsql.asp


  •  

    Posting Permissions

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