length of text fields

  • Thread starter Thread starter Nessa
  • Start date Start date
N

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
 
Hey guys
I'm trying to make the length of my text fields longer --
you know at the momeny they hold 250 characters.
Click to expand...

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?
Click to expand...

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