Can Grow property

  • Thread starter Thread starter db
  • Start date Start date
D

db

Is there a way to specify how much a control can grow? For
example I have a comment field that I want to appear in a
report but if there are more than x characters, print only
that many followed by ... Thanks for the help.
 
db said:
Is there a way to specify how much a control can grow? For
example I have a comment field that I want to appear in a
report but if there are more than x characters, print only
that many followed by ...
Click to expand...


No, but you might be able to set the text box to the maximum
desired height and set its CanGrow to No and CanShrink to
Yes.

On the other hand, how about limiting the number of
characters going into the text box? If the text box uses an
expression like:

=IIf(Len(comment) > XX, Left(comment, XX) & "...", comment)

then the CanGrow should be Yes and it should do what you
want. Just make certain that the text box has a different
name than the comment field name.
 
Thanks. The expression is just what I need.
-----Original Message-----



No, but you might be able to set the text box to the maximum
desired height and set its CanGrow to No and CanShrink to
Yes.

On the other hand, how about limiting the number of
characters going into the text box? If the text box uses an
expression like:

=IIf(Len(comment) > XX, Left(comment, XX) & "...", comment)

then the CanGrow should be Yes and it should do what you
want. Just make certain that the text box has a different
name than the comment field name.
Click to expand...
 
Back
Top