2. ASPRunnerPro General questions
  3. MS Access Character limit 255
This topic is locked

MS Access Character limit 255

 		11/2/2004 9:33:04 AM
ASPRunnerPro General questions
swat author

MS Access does not allow over 255 char. it the table any way to expand this ?
T
 		tsschicago 11/2/2004

Yes, change setting from "text" to "memo" in the "data Type" field in you MS DB. I Think the "memo" field allows 6000 caracters... Hope this was helpfull
lhastings 11/4/2004

adding to Tsschicagos answer.
"Memo" can also slow things down. I have a table with 4000 plus sets of contact details. 1 on the fields is a "Memo". This would take 10 seconds to refresh. Changing the field to "Text", the refresh is 2 secs. I am putting the memo field in a separate table to get around this.
Lee