Entering unlimited text in fields

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

 

[Media Lint]

Data type: Memo (NOT Text)

 

[John Vinson]

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?

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

 

[Guest]

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


.

 

[Guest]

MANY THANKS!

-----Original Message-----
Data type: Memo (NOT Text)

.