? about data type.

[Mike]

The data type Memo only allows you to store 65000+ characters. How do you get
around that when you have a form with a description input text that allow a
user to type in text and not having to have to add another input text box? I
hope that make sense. Is there a data type that will allow you to add more?
Thank you for your replies.

 

[Rick Brandt]

The data type Memo only allows you to store 65000+ characters. How do
you get around that when you have a form with a description input
text that allow a user to type in text and not having to have to add
another input text box? I hope that make sense. Is there a data type
that will allow you to add more? Thank you for your replies.

Do you really expect the user to type more than 30 some odd pages of text for a
single record?

 

[Van T. Dinh]

Slightly incorrect here: the Memo Field can store up to 2 G of characters
(but who would because this is the max size of the database). The Access
TextBox Control, however, can only display 64 K of characters.

I don't expect my users to type even 10 K of characters, though.