Text Field Size - Access 2007

Discussion in 'Microsoft Access Database Table Design' started by WSR, Apr 6, 2010.

  1. WSR

    WSR Guest

    I'm creating a database of text fields. I expect some data to exceed 255
    characters.

    What is the maximum field size of a text field? Can I increase the text
    field size?

    If so I can I do that?

    Your help is appreciated.

    Regards,

    (B^>)-]=[
     
    WSR, Apr 6, 2010
    #1
    1. Advertisements

  2. WSR

    KARL DEWEY Guest

    Use a memo field.
    But remember there are limitations and using functions with a memo as you
    cannot sort it. If you use Left([YourMemo], 255) you can sort that.

    --
    Build a little, test a little.


    "WSR" wrote:

    > I'm creating a database of text fields. I expect some data to exceed 255
    > characters.
    >
    > What is the maximum field size of a text field? Can I increase the text
    > field size?
    >
    > If so I can I do that?
    >
    > Your help is appreciated.
    >
    > Regards,
    >
    > (B^>)-]=[
    >
    >
    > .
    >
     
    KARL DEWEY, Apr 6, 2010
    #2
    1. Advertisements

  3. WSR

    WSR Guest

    Thanks for replying to a level 100 question!

    Regards,

    (B^>)-]=[

    "KARL DEWEY" <> wrote in message
    news:...
    > Use a memo field.
    > But remember there are limitations and using functions with a memo as you
    > cannot sort it. If you use Left([YourMemo], 255) you can sort that.
    >
    > --
    > Build a little, test a little.
    >
    >
    > "WSR" wrote:
    >
    >> I'm creating a database of text fields. I expect some data to exceed 255
    >> characters.
    >>
    >> What is the maximum field size of a text field? Can I increase the text
    >> field size?
    >>
    >> If so I can I do that?
    >>
    >> Your help is appreciated.
    >>
    >> Regards,
    >>
    >> (B^>)-]=[
    >>
    >>
    >> .
    >>
     
    WSR, Apr 6, 2010
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Laser Lu

    Need help on designing an autonumber field with GUID field size?

    Laser Lu, Dec 12, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    265
  2. Guest

    how do i change an access number field to a text field?

    Guest, Feb 23, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    215
    Rick Brandt
    Feb 23, 2006
  3. Guest

    Number Field Size Property - lengthen a Number field

    Guest, Sep 5, 2007, in forum: Microsoft Access Database Table Design
    Replies:
    3
    Views:
    283
    Jamie Collins
    Sep 7, 2007
  4. Bain Davis

    Memo Field in Access 2007 - On Lose Focus, Field Jumps To Top

    Bain Davis, Apr 12, 2008, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    300
    Rick Brandt
    Apr 12, 2008
  5. JimG

    Create field default using the ID field in Access 2007

    JimG, Jul 13, 2008, in forum: Microsoft Access Database Table Design
    Replies:
    0
    Views:
    263
Loading...

Share This Page