I have a string which is in the following format;
The string is created through a custom VB
function and populates a query. I have managed to manipulate the string on a report via another custom VB
function so it then looks like this;
"Code1 450 Code2 300 Code3 450 Code4 50"
However I want each code to be on a separate line - so it appears like this:
This is where I get stuck - has anyone any ideas?
(I don't think I can force the values through a number of text boxes as the number of codes could change...)