memo field is limiting characters

I have a form that has two memo fields - both are set to "can grow" and you
can type as much as you like into the fields but when you move on to the next
one the entered text is truncated to 255 characters??

Allen Browne has an excellent short paper on this phenomenon:

http://allenbrowne.com/ser-63.html

The Can Grow Proeprty, by the way, only applies to reports or forms ***if
they're being printed*** which, of course, they shouldn't be.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201001/1

On Fri, 8 Jan 2010 15:28:01 -0800, brandee
wrote:

I have a form that has two memo fields - both are set to "can grow" and you
can type as much as you like into the fields but when you move on to the next
one the entered text is truncated to 255 characters??

Some confusion of levels here!

Forms don't have fields. Forms have *textboxes* - which may or may not be
bound to fields in a Table. There is no such thing as a "memo field on a
form"; you can have a Memo field in a Table, and that field can be bound to a
form textbox.

Secondly, the "can grow" property does not affect the number of characters
that can be entered, but only the height (in inches or centimeters or twips)
of the textbox when it is printed. It does not affect what you see on the
screen.

My guess is that you have a Format property set on this field in the table, or
on this textbox on the form. A Format will truncate the memo field. There are
other reasons, see the reference elsethread.
--

John W. Vinson [MVP]