Breaking up a sting

[garyd1234]

Hi,
I have a text box on a form that i want someone to enter text into line by line. They will break the lines by pressing CTRL ENTER to go to a new line. I want to break up the text box into its respective lines and read where they pressed ctrl enter.
Example
This is line 1
This is line 2
This is line 3

I want to take each of these sentences and put them into seperate records in my database. How do I split it apart since, when I print the contents of the text box, this stuff is all concatenated together with little boxes in between them where the carriage returns are? Thanks

 

[SydneyGeek]

Hi Gary,
is there any reason why you can't provide the users with a subform in Datasheet view, displaying only the field that you want to use for data entry? That way, they place the data in separate records automatically.
If I have missed the point, please let me know.

Denis