Line break on appearance of a comma

  • Thread starter Thread starter Jim Adamson
  • Start date Start date
J

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
 
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
 
Back
Top