Splitting a single field into multiple report textboxes or multi-line textbox (1 Viewer)

DKeith

New member
Local time
Today, 17:44
Joined
Jun 4, 2013
Messages
1
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

I will always be a newbie
Local time
Today, 18:44
Joined
Apr 1, 2012
Messages
489
Look at the Split() function.

Split(expression[, delimiter[, limit[, compare]]])

Dale
 

Users who are viewing this thread

Top Bottom