How to get Commas in Number Data

[vbjewel]

I am trying to send data from an MDB to a report. In the tables the Number data has commas and once VB reads it into the report (I use it by reading straight from the DB not by a variable IE: rs!field1) the commas do not print or show. Any suggestions on how to print the commas or format this data??
Thanks

[Lethal]

What type of report software package are you using??

[vbjewel]

Unfortunately I am not using a reporting 'tool' I am coding reports to go straight to the printer through
the Printer.Print.

Did this initially because I need to print different columns across a report and VB report wouldn't allow it, Word was a pain in the butt, I didn't have any other tools and I had to get this out on the fly. Attempting to get Crystal Reports here.

Any comments..

[jbart]

Have you tried using the format command ?

    Dim x As Integer
    x = 20500
    Debug.Print Format(x, "###,000")