"Capitalize" text format screws up CanGrow 1

[boxboxbox]

I have a report of address labels, and the text boxes are set to Can Grow = Yes and that works fine (when the city/state/zip line is too long it makes a new line).

Now, I need it to format the addresses in capital letters (I don't want to have the addresses be in capitals for anything else; it is hard to read, so I prefer formatting them only on this report) so I put ">" in the format property for all the text boxes. The addresses are all now in capitals, but this seems to stop the Can Grow feature from working--the text is just cut off where the textbox ends.

Is this a known issue? Any work-arounds other than typing the addresses in capital letters?

Thanks.

 

[HitechUser]

boxboxbox,

Instead of using ">" try using this..

StrConv (fldName, 2)

Specify this on the control to covert the value to uppercase first.

Hope this helps..

Good Luck...

 

[HitechUser]

boxboxbox,

Hey a typeo ERROR use this..

StrConv (fldName, 1)

Sorry............

 

[GingerR]

Hi. I don't think it's making the Can Grow not work. I wonder if it a combination some how of your margins, page setup, detail size, column layout, headers and footers? I haven't been able to make Can Grow NOT work, and I've changed around those features I just listed and it's still fine. Maybe if you tell your exact specs it will help us help figure it out.

 

[boxboxbox]

This seems to work nicely, HitechUser, thanks:

StrConv (fldName, 1)

GingerR - let me see what details I can find...

 

[boxboxbox]

In case you want to find an alternate solution:

Margins:
.513
.5
.253
.25

Columns:
2
.0597
.3
Width: 3.8201
Height: 1.8

Textboxes:
Left: .1
Top: .3333
Width: 3.5021
Height: 0

Pretty much I just put them on top of each other, and it worked properly until I tried the ">" formatting...I tried expanding the city/state/zip textbox by width and also by height. With extra width it would show more and then cut off, with extra height it did nothing but move the country line down.

Oh, and both of you were awesomely speedy to reply, and I appreciate it. Thanks again!

 

[GingerR]

hmmm...sorry but I can't replicate it. Works fine for me. I put in addresses up to 255 characters and it works. Maybe give me a data example that doesn't work cause maybe I don't have my fields set up like yours are. I have 'streetaddress' and one field for city,state and zip just to use as my own samples.