is it possible to increase field size beyond 255

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

Guest

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

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.
 
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
data?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top