Splitting a single field into multiple report textboxes or multi-line textbox

[DKeith]

I have a single field in a table called "Client Contact", where users enter a semicolon between the name, address, and city state & zip. My reason for this was so we could copy client info with a single copy and paste (like from an email). But, on the final report, it needs to have these three parts split up into different lines, or even different textboxes. I can't find a way to do that.

[rzw0wr]

Try this.

http://office.microsoft.com/en-us/ac...001228911.aspx

Dale

[DKeith]

Not sure where to use that. Do I insert the formula in the textbox where I want the results, or in vba in the "On Current" or "On Load" event?

If in the textbox, it's not returning anything.

If this is in VBA, I'm not sure how the coding would work.

[rzw0wr]

You might try using it in the report.
You want to split the field and show it in several text boxes on the report.
I would try adding it to each text box on the report.
Start each with =

Dale

[DKeith]

When I enter the formula in the text box, it's telling me to enter a parameter value for Split.

When I enter the formula in the the label, it just shows the formula.

[DKeith]

I'm entering =Split([Client Contact],";",0)

[rzw0wr]

try this in the text box. You can not enter functions (code) in a label.
=Split([Client Contact], ";",X)
X will return the number of substrings.
0=1st, 1 = 1st and 2nd
-1 returns all substrings.
The extra code is one reason why we do not put more that one bit of data in a field.
The best practice is to have a field for each bit of data.
Firstname, lastName.........

Dale

[rzw0wr]

Sorry,
It appears that Split() doe not work in the Row Source as I thought.

Dale