auto size label

[iccsi]

I have a report needs to support 2 languages
since 2 languages has different length.
I am looking for the property of canShrink or canGrow or autoFit to
have the label size to fit 2 languages.

Are there any propery or method for this? if not, are there any
workaround?


Your information is great appreciated,

 

[Marshall Barton]

I have a report needs to support 2 languages
since 2 languages has different length.
I am looking for the property of canShrink or canGrow or autoFit to
have the label size to fit 2 languages.

Are there any propery or method for this? if not, are there any
workaround?

Assuming you want to adjust the width's of the labels, then
try(?) using the report method TextWidth (see VBA Help for
details). Them set the label's Width to a little more than
the value from TextWidth.

If the Height needs to be adjusted, then use a text box with
its CanGrow property set to Yes.