MS VB and Access... and the MultiLine Text box

[THCi]

Hiya folks,

Ive got to do a small project for my computing course, Its been going well. But, now Im stuck. Ive obviously searched google but had no luck there.

What I want to do is read each line of a multi-line text box into a database, creating a new entry within the table for each file found. Does anybody know of a way to do this?

Or, is there a way to use a list box, as when I select the file, I want to be able to play it, and edit details about it as well.

Any help muchly appreciated!

Nath'

[Shad]

What I want to do is read each line of a multi-line text box into a database, creating a new entry within the table for each file found.

Read that line back to yourself and explain it again - where did the files bit come from??

[Spunkey]

hello!
to split a multiline text box by line try the following code mate;

egg = Split(Text1.Text, vbCrLf)
For i = LBound(egg) To UBound(egg)
  MsgBox (egg(i))
Next i

[THCi]

thanks dude, worked like a treat!