8/20/2009 2:00 pmkaren.marley367377

Validation Number - with Comma Separators

Hi - I am using ASP with Access, Two Fields are set to long integer with standard (10,000) formatting.

I want to keep the fields as numeric as eventually they will provide a search function, for example, search 10 - 50

I have validated to number 0 - 100000, using English (10,000) formatWhen the figures are inserted directly into the database, the comma seperator appears fine, but when inserted on both the insert and update pages the figures do not include the comma seperators. Is there a way to allow users to insert comma seperators (currently doing this ignores the figures after the comma)...