Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    29

    Unanswered: increase the fieldsize

    Hi,

    I have a text field in my database. I know, maximum number of characters we can enter is 255. Is there any way that I can increase the fieldsize beyond 255?
    Please help.

    Thanks

  2. #2
    Join Date
    Aug 2004
    Location
    Steamboat Springs, CO
    Posts
    37
    Use the memo data type

  3. #3
    Join Date
    Aug 2004
    Location
    Steamboat Springs, CO
    Posts
    37
    Use the memo data type....basically unlimited characters...up to 65K can be displayed

  4. #4
    Join Date
    Feb 2002
    Posts
    108

    Talking

    But beware you can't sort on a memo field, if that is a problem create another field that is the first characters of the new memo field and sort it behind the scenes.

  5. #5
    Join Date
    Jul 2004
    Posts
    29
    Thank you very much for your help.

Posting Permissions

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