Hi All,

I am extracting an text field from my Access database which is 255 characters in length. I need to put this information within smaller fields of 45 characters. I need to split the field into an array with each part of the array being 45 characters. However what I don't want to do is split any of the words e.g. "techn" CR "ology". In other words I need the length of the array variables to be 45 characters or less and split within the spaces " ".

Any ideas?
I am not sure how to combine the Left command and the split command to accomplish what I need.

Any help with this issue would be greatly received.
Many thanks,

Paul