Unlimited text in text boxes

[Devsar]

Please could someone help? I have created a database using access 2003. The
database lists local groups and has various types of respone. One of the
responses requires them to write a paragraph about the group, however when I
try to tyoe that in to the text box on the form, the box will only let me
type in a limited amount of text, (approximately 10 words). How do I change
the text box so that it has no limit on the amount of text that can been
typed in to it?

Thanks

Sarah

 

[Devsar]

Thanks for that Jeff, I'm probably being very thikc here, but how do I check
the size, I looked in properties but wasn't sure I was in the right place.

Sarah

 

[Douglas J. Steele]

Jeff's talking about going into the Table Design view and looking at the
size of the table field to which the text box is bound.

 

[Jeff Boyce]

Go to the table on which the form is based. Open the table in design view.

Go to the field that corresponds to the text box on the form. Check the
size. I'm guessing it is set to "50" characters.

If you need up to 255, continue using a text box. If you need something
more ("unlimited"), change the data type to a "memo".

Note that you may need to delete and re-add the text box control on your
form (if it doesn't "pick up the fact" that the underlying field is now
"memo".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Devsar]

Wonderful, if you weren't both faceless beings on the other end of the
computer I would kiss you both, I've been trying to figure out how to do that
for the last week