HELP, MEMO Box does not grow when typing (1 Viewer)

[Samrasr]

I have a form which has a MEMO box. I want my users to type in the memo box, each time they type in the box, i want the box to expand/grow as they type or hit return. I have seen this on another database.

Whats the best way of doing this and please explain in basic as im not good at computers.

At the moment my users have to use the scroll bar which i do not like.

Please see the Photos for more information.

Form is the database im working on now which has a scroller.(dont like)
FORM 2 is the database i want the memo to look like.(i like)

I have already tried the options of grow and shrink. Still dont work, maybe i need a code.

Please reply in very basic detail as im not good at databases!

 

[missinglinq]

The CanGrow function in Access only applies to printing/reports. Stephen Lebans has a sample database that mimics CanGrow for forms. You can download it at

http://www.lebans.com/cangrow.htm

Good Luck!