String and Access Memo field

Results 1 to 2 of 2

Thread: String and Access Memo field

  1. #1
    Join Date
    Dec 1969

    Default String and Access Memo field

    I have a HTML text area box in a form. When the user inputs data into it, it only writes the first 255 characters into the database column (which is an Access 97 Memo field). Can the variable that holds the text hold more than 255?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: String and Access Memo field

    Microsft says that a variant has the same amount of storage capacity as a variable-length String and a variable-length String can hold approximately 2 billion characters, so I would start looking some place else. I don&#039t use Access as a backend for my ASP sites, but I do seem to remember hearing about issues with the memo datatype - sorry I can&#039t be of any more assitance - if all else fails, I imagine a dirty way to deal with this would be to chop the string up into sections of 250 characters.<BR><BR>good luck<BR><BR>bart

Posting Permissions

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