Line break on appearance of a comma

[Jim Adamson]

Hi,

I'm creating some mailing labels with address, town and postcode
fields, using the Label wizard. The trouble is some of the address
fields are longer than say "42 Garrison Way", for example "West View,
Allens Lane," which means the labels would look oddly presented, e.g.:

West View, Allens Lane,
Hertford

Is there a way I can force a line break/new line after a comma occurs
in the address field so that the previous example would look like
this:

West View,
Allens Lane,
Hertford

I have used commas to seperate out the fragments of the address in
quite a few records, so 'd rather not create an additional
address(part2) field.

thanks all
Jim

 

[Jim Adamson]

thankyou Steve, I'll give it a go. Did you just write that code or had
you already written it for something else ? cheers Jim

 

[Jim Adamson]

Steve,

Worked a treat !

cheers
Jim