Format Numeric Field To Show Commas
Posted on 2002-05-15
I'm using VB6 against an SQL Server database.
Does anyone know of a format function where I can check for a valid number entered with these requirements:
--Must Be Numeric
--Can have commas
--Cannot have decimals
We need this since we are going to take this number and insert it into a sql server table.
I tried format (txt1,"Currency") but this allows for decimals.
Thanks in Advance