ListBox bound to Access Database?

[Smie]

How would I save data in listbox format in an access database? Ive tried a number of things, but no luck...thanks

[Clunietp]

Do you want to use ADO or DAO? Why not save to registry?

[Smie]

DAO and, I dont want to save to registry because I need the info in a database

[Smie]

Thanks, but what i need to do, is when your inside Access(making the database) you can choose what type you want the data to be saved as Eg.

Text
Button
Checkbox
Listbox

The normal is text, i have gotten checkbox to work, but not listbox, any help?

[netSurfer]

What exactly do you mean 'Save data in a listbox forat to database'? Do you mean you want all the data in a list box saved into a database? Each in a seperate field or all data into 1 field?

If you want to take all the data from a list box and save into 1 field in a database, I would set up a loop to cycle through the entries, add chr(34)-" on either side, and seperate by commas and dump into a string. Then write this string into the database field.--> string = "data1","data2" etc.

If this isn't what you mean, can you be more specific?

[This message has been edited by netSurfer (edited 01-11-2000).]