Text field size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
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


Jenn@iao said:
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
Click to expand...
library.
 
Back
Top