Re: CanGrow on a form's detail section

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Paul Kraemer wrote:
Hi,

I have a subform that displays records in tabular format. One of the
fields that I am displaying is of type 'Memo'. In most of my
records, this field is empty. When it is not empty, it usually
contains between 1 and 5 lines of text (the user hits the <enter> key
to move to the next line).

When I created the TextBox for this field on my subform, I drew it
only one line high. I set its 'Can Grow' property to true. I also
set the 'Can Grow' property of my subforms detail section to true as
well.

I was hoping that this would cause the Textbox height to be one line
high when it was either empty or contained only one line of text, and
that it would expand to show multiple lines when additional lines of
text are present.

This did not work. Even if the field contains multple lines of text,
my TextBox only shows one line.

Is what I am trying to do impossible? Or am I just missing something?

CanGrow (in forms) only applies to when you print them. S9ince printing
forms is a bad idea anyway the property is mostly useless.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.



Relevant Pages

  • Re: CanGrow on a forms detail section
    ... field fits the text you could use a Flex Grid control. ... I have a subform that displays records in tabular format. ... When it is not empty, it usually contains between 1 and 5 lines of ... When I created the TextBox for this field on my subform, ...
    (microsoft.public.access.forms)
  • Re: Fixed view of Form?
    ... >>subform contains records of items to be purchased. ... The paper form shows ten empty line items numbered from ... How can I automatically add ten empty records numbered from one to ten? ... > Dim iNext as Integer ...
    (microsoft.public.access.forms)
  • Re: Subform wont show data in Access 2007
    ... The LinkChild and LinkMaster are empty; ... I also converted the MDB to Access 2007, just to see if a conversion would change something, but the problem remained. ... 2007, the subform won't populate. ...
    (microsoft.public.access.formscoding)
  • Re: subform variables not showing up in main form-only one blank row with field head
    ... field with these two fields being empty (because date will be inputed along ... and then the corresponding subform will provide the ... everyday and since there can be no repeats for a primary key i decided to opt ...
    (microsoft.public.access.formscoding)
  • Re: Reading a field when field is locked?
    ... MsgBox "dr is not empty" ... The above expression returns a reference to the subform control on the main ...
    (microsoft.public.access.formscoding)