beyond the 255 character limit

[Guest]

I have a form where I need to enter a large amount of text into just one
field. It exceeds the 255 character limit (the maximum Access allows).

Is there a way that the user can continue to type and once it reaches the
255 character limit, it begins to type in another field without the user
having to stop typing and click on the next field?

 

[Dirk Goldgar]

I have a form where I need to enter a large amount of text into just
one field. It exceeds the 255 character limit (the maximum Access
allows).

Is there a way that the user can continue to type and once it reaches
the 255 character limit, it begins to type in another field without
the user having to stop typing and click on the next field?

If you bind the text box to a Memo field instead of a Text field, you
can store up to 64K characters in it using the text box. In fact, you
can store up to 2GB (theoretically) in a memo field, but a text box will
only let you enter up to 64K.

 

[Guest]

If I change the field from a text box to a memo, the text that is inserted in
the field never changes when you go to a new record. It carries the same
values throughout the form.

I need the field to reset like a normal text box for every new entry.

 

[Guest]

jman,

I think you may have replaced a textbox *control*, which lives on a form, to
a label control, which would of course be the same on all records. Dirk is
suggesting that you keep your textbox on your form, but change the *field*'s
Fieldtype in table design view from "Text" to "Memo".

Sprinks

 

[Guest]

Aha! I initialy set up the memo correctly (via table), but I had deleted the
control for the field in the form design.

Thanks for your help!