can grow label

[iccsi]

I have a label on the report, because I need put the caption at run
time. I would like to have it can grow, because the caption length is
different every time I got from tables.

I tried to convert it to text box which has can grow property, but I
can not assign string at run time, I have to link to a data source.

Are there any way to have a control on the report have can grow
property and set caption at run time?

Your information is great appreciated,

 

[Jeff Boyce]

I'm pretty certain I have controls (textbox controls) in my reports that
derive their values at runtime.

Are you getting an error message? What does it say?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Allen Browne]

As Jeff says, you can assign a value to a text box at runtime, but you have
to choose the right event.

Try the Format event of the section that contains the text box. (The Print
event is too late to take advantage of the CanGrow property.)

Report_Open is too early. Well, actually you can set the ControlSource but
not the Value of a text box in this event, so you could use:
Me.Text1.ControlSource = "=""Say something""."

Similarly, trying to assign the value from other code (e.g. in a form) after
the report is open will be too late.