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) 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.WADAUpdateForm.Size,0,false);WAValidateNM(document.WADAUpdateForm.SizeMax,'Maximum Size : Invalid number format. Add Numbers - no spaces commas, or decimal points',0,100000000,0,'','',',.',document.WADAUpdateForm.SizeMax,0,false);
I am sure there must be a simple answer to this ! X
Many thanks