Text field size

[Jenn@iao]

I am using Microsoft Access 2000. I am trying to customize a field size with
text, in a table to be more than 255 characters. I am entering large amounts
of text, i.e. many article titles from various journals for a company library.

 

[John Vinson]

I am using Microsoft Access 2000. I am trying to customize a field size with
text, in a table to be more than 255 characters. I am entering large amounts
of text, i.e. many article titles from various journals for a company library.

Use a Memo field instead of a Text field. That will give you 65536
characters (actually a gigabyte if you fill the field
programmatically).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Duane Hookom]

You can use a memo field to enter more than 255 characters. I question your
table structure when I see that you are entering many of something into a
single field.

--
Duane Hookom
MS Access MVP

I am using Microsoft Access 2000. I am trying to customize a field size with
text, in a table to be more than 255 characters. I am entering large amounts
of text, i.e. many article titles from various journals for a company

library.