Can Grow for number fields

[dev1212]

Hi,

I have a number field, i want it to grow/wrap automatically as text objects does in crystal. When i right click the number field the 'can grow' option is grayed out, its disabled.

Is there any way to do this..?

I know we can use CStr() formula to change change the datatype to text and then use 'can grow' but i dont want to use 'CStr()' formula because when i export the report to excel then all the text objects appears as text but i require the number field to be number and wrapped (can grow) both at the same time.

Please let me know if there is any solution to this.

Thanks

 

[Madawc]

Sorry, 'can grow' applies only to text.

What are you after? If it is a problem of display, you can use a smaller font. You can even do this selectively depending on the value, this is one of the 'Format Field' options.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[Salad82]

Put the formula in a text box and set can grow on the text box.