I asked this on the 4guysfromrolla forum and got yelled at, but I can't find it answered anywhere!
Let's say one field in my recordset is defined in Access as Standard Number. Anyways, many times this will be a fairly large number; when I'm looping through code to output the values of this field, the number is a integer without commas. Is there any way I can declare the number as a Standard Number as opposed to a General Number, as I can when I originally wrote the database in Access, which will get appropriately placed comma breaks?
Let's say one field in my recordset is defined in Access as Standard Number. Anyways, many times this will be a fairly large number; when I'm looping through code to output the values of this field, the number is a integer without commas. Is there any way I can declare the number as a Standard Number as opposed to a General Number, as I can when I originally wrote the database in Access, which will get appropriately placed comma breaks?
