Entering unlimited text in fields

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I created a 'Notes' field. It is currently limiting the
amount of text I can enter to about 200 or so. How do I
set this field so that it will accept an unlimited number
of text?
 
I created a 'Notes' field. It is currently limiting the
amount of text I can enter to about 200 or so. How do I
set this field so that it will accept an unlimited number
of text?
Click to expand...

You cannot. Your hard disk doesn't have an unlimited amount of space,
and an Access database is limited to 2 GBytes.

If 65536 bytes is enough, however, change the field type to Memo
instead of Text. (You can actually get a gigabyte into a memo but you
have to use code to do so, not typing).
 
MANY THANKS JOHN!
-----Original Message-----


You cannot. Your hard disk doesn't have an unlimited amount of space,
and an Access database is limited to 2 GBytes.

If 65536 bytes is enough, however, change the field type to Memo
instead of Text. (You can actually get a gigabyte into a memo but you
have to use code to do so, not typing).


.
Click to expand...
 
Back
Top