I was wondering if anyone knows how to split a multiline textbox in Access to single lines like for an insert into a Table.
say i have:
Apple
Banana
Cherry

in a text box i want to insert each value into a seperate line in a table with one field.
I am wondering if a simple Split(string, vbCrLf) would work or not. Any help with this would be great.

EDIT::: I have figured out how to split it

-Cryptodoggy

It's common practice to post what the actual answer to the problem was ...
otherwise people reading you post just get frustrated

Say you have textbox with this in it

-------------------
| Apple |
| Banana | < -- Named txtFruit
| Cherry |
| Mango |
-------------------

you want the 3rd item from the box
sResult = Split(txtFruit, vbCrLf, ,vbTextCompare)
Msgbox sResult(2)

This will Return "Cherry"
PS: Sorry about not posting the answer was kinda busy after i figured it out.

-Cryptodoggy

tnx