Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-15-2018, 11:24 AM   #1
thirumurugan
Newly Registered User
 
Join Date: Sep 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
thirumurugan is on a distinguished road
Cool concatenated multi row text in single column

hi,

pls help how to concatenated multi row text in single column via VBA Code
i have attached text.dbs file whats my requirement

pls help provide with samble database with VBA CODE



Attached Files
File Type: accdb text.accdb (452.0 KB, 10 views)

thirumurugan is offline   Reply With Quote
Old 09-15-2018, 11:30 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,218
Thanks: 10
Thanked 3,903 Times in 3,846 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: concatenated multi row text in single column

You can adapt this:

http://allenbrowne.com/func-concat.html

using a vbCrLf instead of a comma.
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Column names and multi-cells to single cell NT100 Excel 3 03-20-2018 07:14 AM
multi concatenated textbox to an individual row BBBryan Queries 5 10-02-2014 03:28 PM
List boxes: single column vs multi column scubadiver007 Forms 6 04-04-2013 04:43 AM
Re: Concatenate Column Values from Multiple Rows into a Single Column Snuffy94 Queries 2 07-19-2012 08:54 AM
[SOLVED] Multi-Column Combo-box won't bresk down in text boxes JimLynn Forms 2 08-16-2005 06:23 PM




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


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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