Validation Number - with Comma Separators

[karen.marley367377]

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) format
When 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)...

WAValidateNM(document.WADAUpdateForm.Size,'Size: Invalid number format, do not use spaces, comma seperators or decimal points',0,100000000,0,'','',',.',document.WADAUpda teForm.Size,0,false);WAValidateNM(document.WADAUpd ateForm.SizeMax,'Maximum Size : Invalid number format. Add Numbers - no spaces commas, or decimal points',0,100000000,0,'','',',.',document.WADAUpda teForm.SizeMax,0,false);

I am sure there must be a simple answer to this ! X

Many thanks

[Eric Mittman]

The reason you are getting the numbers inserted without the comma is because you have specified that the column type is numeric.

If you store the comma in with the number you will need to have the column set as a varchar type.

In the database all of these values should be purely numeric, this means you will not be able to store the comma in the number. It is best to have the numbers unformatted in the db, then just format the numbers server side when you want to display them.

Doing a little looking on the web I found this link that has a formatting function, the Standard format looks like the one you are going for.

http://www.texaswebdevelopers.com/examples/format_asp.asp