Memo field to separate lines

OzGreg

Registered User.
Local time
Today, 23:53
Joined
Dec 9, 2015
Messages
10
I have an access database and need to split my memo fields (Source Data.png) into separate lines as per the results in (Output.png)

I have attached pictures to visually show what I am trying to do, its easier that a lot of confusing word's

I have also attached the sample access database which has the source data table to be converted (tblCatalogueDesc) and a form for the button to go on to run the required code/process to convert the data.

The tblLongText Load File is just a sample output as a guide in the database.

I am sorry that I am not good in the programming side and don't know how to add it to a command button. I have used Access for over 25 years but never had to do any heavy programming etc, so treat me like a newb :o

Any help will be appreciated, thank you

Cheers, Greg
 

Attachments

  • Source data.png
    Source data.png
    16.1 KB · Views: 94
  • Output.png
    Output.png
    24.9 KB · Views: 90
  • Text.accdb
    Text.accdb
    572 KB · Views: 73
Open the attached database and press the button in the form.
 

Attachments

Thank you JHB

Works fantastic, really appreciate the help

Cheers, Greg
 
You're welcome, good luck. :)
 

Users who are viewing this thread

Back
Top Bottom