length of text fields

[Nessa]

Hey guys
I'm trying to make the length of my text fields longer --
you know at the momeny they hold 250 characters.

I would like to have a longer text field so it can hold a
description of a product talking about maybe up to 10-20
lines of text.
Any ideas on how to do this?

Thanks a lot
Nessa

 

[John Vinson]

Hey guys
I'm trying to make the length of my text fields longer --
you know at the momeny they hold 250 characters.

255 to be exact, a limit which cannot be stretched.

I would like to have a longer text field so it can hold a
description of a product talking about maybe up to 10-20
lines of text.
Any ideas on how to do this?

Use a Memo field instead of a Text field. That'll give you 65536
characters, unless you use VBA code to load it; then you're limited to
a gigabyte.

 

[Van T. Dinh]

Use a Memo Filed instead.

Text Field is limited to 255 characters. Memo can be up
to 64K characters (limit of a TextBox Control) or much
bigger (1 GB?) if entered via VBA code.

HTH
Van T. Dinh
MVP (Access)