255 characters not enough in text box!!! (any ideas)

[rich_bell20]

hello everyone, any help much appreciated....
i have an estimate form where the user enters a job estimate, they also type a job description in a text box describing what they are going to do... thing is its not big enough. Is their a way of making it even bigger, or importing a word document or something... at the mo i am over coming this by making an additional text box called job description2, where, when he runs out of space he goes onto the next one, surely there is a better way!!??

Thanks

Richard Bell.

 

[Fuga]

there is a memo field type.

Fuga.

 

[missinglinq]

FUGA's right, a memo field is the way to go. A memo field has a 64,000 character limit instead of 256 characters. Another nice feature with the memo box is the ability to expand the box for entering, editing,and reading data, and then shrinking it so that the it takes up a small amount of space on your form. To expand the box you simply select it then hit SHIFT + F2. The box expands for easier data entry. You then click on OK and it shrinks back to the original size.

The Missinglinq

 

[Cosmos75]

Another nice feature with the memo box is the ability to expand the box for entering, editing,and reading data, and then shrinking it so that the it takes up a small amount of space on your form. To expand the box you simply select it then hit SHIFT + F2. The box expands for easier data entry. You then click on OK and it shrinks back to the original size.

I did not know that! COOL!

 

[PookaTech]

Is there a way to do the zoom thing (Shift F2) on the memo box using code other than just a send keys method?

Thanks,
Pookatech

 

[Rich]

DoCmd.RunCommand acCmdZoomBox

 

[PookaTech]

Thanks Rich.

Pookatech