Field size

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


.

Relevant Pages

  • Re: Form/Subform
    ... The issue is that users don't think in terms of "related records" and "what ... so detail records before entering a project number, ... Better to cancel the BeforeInsert event of the subform if the main form is ... I recently discovered that if the user enters detail records without first ...
    (microsoft.public.access.forms)
  • Re: query wont return results
    ... record in that table before you can enter a related record in tblHoles. ... your data entry process first needs to focus on entering data ... Create a form that is based on a query that uses tblCourses as its data ... LinkChildFields properties of the subform control) where the subform is ...
    (microsoft.public.access.queries)
  • Re: I want my subform to stay "locked" to my main form.
    ... and/or main form data with incorrect subform data. ... For some reason, I ... to the related record shown in the parent form. ... Proper relationships would prevent you from entering a child record without ...
    (microsoft.public.access.forms)
  • Re: Form/Subform
    ... value if they ultimately get around to entering one somewhere. ... Better to cancel the BeforeInsert event of the subform if the main form ... Better yet to mark the foreign key field in the ... I recently discovered that if the user enters detail records without ...
    (microsoft.public.access.forms)
  • Re: Table design problem?
    ... The popup form would be essentially the same as the current form (would have ... >>> a Mainfrm and they enter their production within the sub form. ... >>> information within the Main form and closing the form without entering ... >>> and they cannot enter directy into the Subform because it is linked to ...
    (microsoft.public.access.tablesdbdesign)