I'm sure this is simple, but I'm stumped.

I have a field on my form where I display the dollar balance of that record. In the database this is a numeric field with 2 decimal places. On the form, it's a simple textbox where I set the control source to a variable. To make this simple, the variable looks like this...

jval='$'+alltrim(str(tcursor.sum,15,2))

jval ends up looking like...

$123456.00


Here's how I want it to look...

$123,456.00


Any advice is welcome.

Thanks!