Field size

[JB]

Hello
I have a subform that is continuous. Theres's a field that is memo and the
Key behaviour has 'Enter new line'.
The users will be entering anything up to 3 lines but mostly 1 or 2. I've
got the height of the field to show 2 lines which is looking good, viewing
3 takes up too much space and is a waste a lot of the time. .
but what I would like is that if there happens to be 3 lines entered (rather
than have the field vertical scrollbar) I'd like the field height to grow to
view all 3.
Is that possible?
Thank you

 

[Peter Hibbs]

JB,

The problem with a Continuous form is that if you make the height of
one record larger it will change all the records on the form, which is
probably not what you want. If you want the individual records to
adjust to different heights depending on the number of lines of text
in the record then you could use a Flex Grid control. You would need
to be able to write some VBA code, however.

Have a look at my Flex Grid Demo program at :-
http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4
which has an example of what you are trying to do.

HTH

Peter Hibbs.