Can grow problem

[John]

Hi,

I have a problem in using the can grow property for a text box. I am
using Access 2000 (9.0.4402 SR-1). I have created a text box in the detail
area of a report. The content of the text field is to concatenate and
display a list of discount value. The formula likes this : =IIF([discounta]

0, str([discounta]) & "% ", "") & IIF([discountb] > 0, str([discountb]) &

"% ", "")....... and so on. However, I found that the can grow = yes option
does not work for this text box.

No sub report is using in this case. Border Style = Transparent, format
= standard, special effect = flat, border width = hairline, can shrink = yes

I do not know how to fix the problem. Please help me to fix of it.

Thank you for your help.

Rgs,
John