Format Strings

[glove]

If I have a table with a field containing a string such as "Test1;Test2;Test3", is there a way to pull the values from that string, perhaps using the MID function, and display them in a report as:

Test1
Test2
Test3

Any suggestion would be appreciated. Thanks.

[sig][/sig]

 

[sdb510]

Try this:

Dim OldString as String
Dim NewString as String

OldString = "Test1;Test2;Test3"

NewString = Replace(OldString, ";", vbCrLf)

This will replace the semicolon with the carriage return/line feed character.

Steve
[sig][/sig]

 

[glove]

Thanks for the reply Steve. The codes works fine, but why can't I use the function "replace" in a query or report? I get an error that says it is an unknown function. [sig][/sig]