User Input Strips Commas

Hi,

I am trying to get it to display a prompt box that will display entries with a certain ID.

This query can be used to get the records with the IDs of 1 and 8:
SELECT * FROM table WHERE id IN(1,8);

Now this code can be used to get a record with an ID number that the user specifies:
SELECT * FROM table WHERE id=[Enter the ID Number];


So, I tried to combine the two together with this:
SELECT * FROM table WHERE id IN([Enter the ID Number]);

This however doesn't work because the prompt strips out punctuation - so if I type "1,8" in the box, it displays record 18.
Any ideas?