VB.NET Help Next Record and formatting

Question

Help Please. Struggling to learn vb.net to finish this project I was given. I have a webform that I can get to display a record and move to the next record. The problem I am having is with the Money fields in the next record are un-formatted. How do I get them to show as money? A line of code from the Next Record button is: dr = dt.Rows.Item(i) tbNewInventoryEq.Text = dr.Item(Cap_New_Inventory) Thank you in advance. Throw an accountant/programmer wanna-be into a programming project and you've got a fish out of water.

Adam Erstelle · Answer

Try this: 'declare the single variable used for storing the number to format dim sngCurrencyValue as single 'populate the Single variable sngCurrency = cstr(dr.Item(Cap_New_Inventory) 'format the text of the textbox to be currency. tbNewInventoryEq.Text = String.Format({0:C} sngCreditlimit)