I have a form in which the user enters several amounts, which have a data type of "money" in SQL Server. Those amounts are used to calculate a savings amount, which may then be modified by the user if necessary. I have the amounts displaying with a currency format. The problem is that when I store the calculated value to the savings text box, it does not display in formatted text. If I store the new value as a formatted string, I get an error converting the string to a decimal.
I tried
this.txtSavingsAmt.Text = calculatedNumber.ToString();
oMyBizObj.CallStateChange(OakLeaf.MM.Main.Business.mmBusinessState.Bind);
but that sets it back to it's original value. For the moment, I'm just leaving the calculated number unformatted. Once it's saved, of course, the correct formatting is displayed. Does anyone have a way to get the currency formatting to display correctly before the save? Thanks.
Linda Harmes
HiBit Technologies, Inc.