[RESOLVED] Split Database data into label size

[AndyGable]

Hi All,

I Hope someone can advise me and what I need to do to get this to work.

I have a database that has a field called SELDescription and this can be upto 100 chrs long (hold the description of a product) for example

JOHNSONS BABY COTTON BUDS 100PK

At the moment I can get the first 18 chrs so I would have "JOHNSONS BABY COTT" but I would like it so if a word is cut off half way for that to be placed onto the next line

so the label would look like this


JOHNSONS BABY
COTTON BUDS 100PK

and not

JOHNSONS BABY COTT
ON BUDS 100PK

Any advice would be welcomed as the label code has 5 lines of text I can use. (they are called LabDescriptionLine1 - Line5)