GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Micro_soft Access. How do I work with fields longer than 255 characters?

arg · 01-25-2005, 02:26 PM

Two approaches to consider:

1. Use multiple text fields, each 255 characters, like description1, description2, and description3 which you concatinate together for output. If you're just importing them through text files, coding the import to split them into 255-character chunks is reasonably easy. However, if you want edit them from an Access form, it would be a hassle. (Possible with VB, but a hassle).

2. Use a memo field instead a text field. The drawback with this is you can't perform certain operations on a memo field as easily (e.g. string operations like capitalizing letters or appending another string to it). If you're just inputting, editing and reporting the field, that's no problem, but if you do need to perform string operations on it, you need to do some conversions in VB with more complicated library calls.

01-25-2005, 02:26 PM
arg Confirmed User Join Date: Feb 2003 Posts: 1,164	Two approaches to consider: 1. Use multiple text fields, each 255 characters, like description1, description2, and description3 which you concatinate together for output. If you're just importing them through text files, coding the import to split them into 255-character chunks is reasonably easy. However, if you want edit them from an Access form, it would be a hassle. (Possible with VB, but a hassle). 2. Use a memo field instead a text field. The drawback with this is you can't perform certain operations on a memo field as easily (e.g. string operations like capitalizing letters or appending another string to it). If you're just inputting, editing and reporting the field, that's no problem, but if you do need to perform string operations on it, you need to do some conversions in VB with more complicated library calls.