how do i make a field text property unlimited?

[Guest]

i need to extend the number of characters in a field to the maximum (my
preference is unlimited). how do i do that? what field needs to say what?

 

[BruceM]

You can set the field's data type to Memo in table design view. It's not
unlimited, but it can accomodate 65,535 characters (or up to 1 gigabyte if
data are entered programatically).