Database problem

[dan463va]

I'm working on a database and it displays the output in four columns on a multiline textbox on a seperate form. Everything is displaying correctly except I can't get the Unit Cost column to display a dollar sign for the output. I've used:
txtInventory.AppendText(String.Format("{0:C}", objReader("UnitCost"))).

It does not give a build error but the display output is just a number without the currency format. Any help would be appreciated!
Thanks
Dan

 

[lingsn]

How about using this

txtInventory.AppendText(Format(objReader("UnitCost"), "$###,##0.00"))

 

[dan463va]

That worked perfectly thanks so much!

 

[JuggaloBrotha]

couldnt you also do something like:
txtInventory.AppendText(objReader("UnitCost ").ToString("c"))

it may not work though