Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 06-04-2013, 09:57 AM   #1
Newly Registered User
Join Date: Jun 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
DKeith is on a distinguished road
Splitting a single field into multiple report textboxes or multi-line textbox

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.

DKeith is offline   Reply With Quote
Old 06-04-2013, 10:02 AM   #2
I will always be a newbie
Join Date: Mar 2012
Location: USA - Indiana
Posts: 489
Thanks: 24
Thanked 53 Times in 53 Posts
rzw0wr is on a distinguished road
Re: Splitting a single field into multiple report textboxes or multi-line textbox

Look at the Split() function.

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

Please keep in mind as you view my answers I am still a very much a newbie to Access.
Corrections to my post are expected where needed and will be accepted with my humble thankfulness.
rzw0wr is offline   Reply With Quote


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting multi-line text field to have both scroll bars and no line wrap, how? mdlueck Forms 4 09-07-2011 04:53 AM
Build report on multiple values in a single field Demetious Reports 3 09-07-2010 12:21 PM
Parse a Multi-Line Memo Field into Multiple Fields mab9 Queries 2 03-04-2010 10:58 AM
Merging multiple rows from a single field into a textbox maestro83 Forms 23 11-12-2009 01:48 AM
Using multiple formats in single report line Mike Smith Reports 1 10-02-2001 10:59 AM

All times are GMT -8. The time now is 05:22 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World