is it possible to increase field size beyond 255

M

Mobat USA

I have a lot of data to enter into a table, is it possible to increase the
field size beyond the 255 limit? or is there another way to enter this data?
 
R

Rick Brandt

Mobat said:
I have a lot of data to enter into a table, is it possible to
increase the field size beyond the 255 limit? or is there another way
to enter this data?
Click to expand...

Change DataType to Memo. There are some limitations on these (no indexing,
grouping, etc.) and they can get corrupted so it is adviseable to use them
judiciously. They allow up to 64 thousand characters when entered via the
GUI and are limited only by the file-size contraints of the entire MDB when
filled programmatically.
 
L

Larry Daugherty

You can change the datatype to Memo instead of Text

HTH
--
-Larry-
--

Mobat USA said:
I have a lot of data to enter into a table, is it possible to increase the
field size beyond the 255 limit? or is there another way to enter this
Click to expand...
data?
 
Top