Splitting string values in Access report textbox controls

[kenwarthen]

I have a report based on a crosstab query in an Access 2007 database. Some of the report's textbox controls display values that look like "2349|1.00|10 for 10". I'd like to split the values separated by the pipe character and display each in their own textbox control. Any help or advice on how I might achieve this would be greatly appreciated.

TIA,

Ken

 

[HiTechCoach]

I would use something like this:

Dynamic Report based on a Crosstab query

This code could be modified to do what you want.

 

[kenwarthen]

That's a nice sample database, but it doesn't specifically answer my question as to how to split a string value like "1437|1.00|10 for 10" into the pipe separated values and display those values in their own textboxes.

Ken