concatenation & cangrow

[goblue18]

I am trying to Concatenation 2 fields, a name and a number defined as text. When I concatenate it with the 'cangrow' option set, the number field is alway split. How can I keep that number field portion of the concatenation together?

Name = Supply Wholesale
number= 123-4567788

results:

Supply Wholesale 123-4567788


will show (because it is past the size of the field)

Supply Wholesale 123-
45677788

thanks

 

[lupins46]

Make the texbox wider?

 

[goblue18]

there is no room to do that - that is why I set cangrow onto it - so it would wrap to the next time...but it is wrapping in the middle of one of the fields that I am concatenating with

 

[hymn]

try in control source
=[Name] & Chr(13) & Chr(10) &[number]
But the name field must be as wide as the widest name

Hope this helps
Hymn