Text box Query

[jpb]

Hi there,

Has anyone ever tried to enter a series of numbers in a textbox sparated by commas and stored the in the database, similiar to the way in which you would enter a selection of pages to be printed in a print dialog box.
I cant find an examples of it done before and have failed to see it it any books , so I was wondering if anyone has dne it before and if so how might I go about doing it.

Thanks in advance
jpb

 

[SauerC]

I have stored comma separated numbers in a database field before with no problems.

What do you have the field type set to in the database?

 

[jpb]

Hi SauerC,

I am not sure what to store them as . I am using access so data field of type numbers I suppose, with some form of format setting on the type..Could you help me here please as I have never done this before.

Thanks in advance
jpb...

 

[SauerC]

try changing the field datatype to text and you should be able to do what you want.

-Christian