I need a little assistance in coming up with a formula to split a string apart based on length. This is part of a module to export a recordset to an Excel file template for import into my companies system.
My field has a cap of 60 characters, so if the threshold is reached, I need to split the string into a second row but I obviously don't want to cut words in half, so I need to back track to the first space or " " and split the string there. I am very bad when it comes to using string functions (len, left, right, etc) as I dont have much experience with them.
Code:
If IsNull("Description") then
'do nothing'
Else
If Len("Description") > 60 then
'split string'
End if
End if
My field has a cap of 60 characters, so if the threshold is reached, I need to split the string into a second row but I obviously don't want to cut words in half, so I need to back track to the first space or " " and split the string there. I am very bad when it comes to using string functions (len, left, right, etc) as I dont have much experience with them.