grow text box horizontally

[Jake02]

I have a report where I need to insert a currency value into a sentence. Right now, I have a label that says "Please submit the commission amount of " then a text box that shows the amount, then another label with "to the following address." The problem is, depending on the amount of the commission, there is either not enough room for the entire amount to show, or there is too much extra space in the sentence to make it look right. I know there is the "Can Grow" property, but that only seem to work vertically, not horizontally. Is there another way I could do this?

 

[llkhoutx]

Compute the horizontal width.

 

[fearoffours]

In the OnFormat event of the Detail section of the report, place the following code:

Me.txtAmount = "Please submit the commission amount of " & Me.sCommission & " to the following address:"

where sCommission is the name of the field which your text box is based on and Me.txtAmount is a text box (possibly set to CanGrow).
Yell if you need more guidance with this.

 

[johnwatkins35]

do you have an example?