Currency textbox

[kerek2]

Hi All's,

I need to read value from my mdb database into currency format in textbox...can anyone guide me please.tq in advance

[GeekByChoiCe]

take a look into the string formating ;)

[Teme64]

Use string classes Format method:

Dim Money As Double = 1234.56
MsgBox(String.Format("{0:C}", Money))

HTH

[kerek2]

Tq bro,

but still got problem...i cannot change or update that value in this textbox...anyone can guide me please...tq in advance

[Teme64]

Convert currency back to decimal value

Dim Money As Double = 1234.56
Dim MoneyStr As String
MoneyStr = String.Format("{0:C}", Money)

' DEBUG
MsgBox(MoneyStr)

Dim MoneyToUpdate As Double
MoneyToUpdate = [Double].Parse(MoneyStr, Globalization.NumberStyles.Currency)

' DEBUG
MsgBox(MoneyToUpdate)

You should put [Double].Parse in a Try...Catch...End Try block or use [Double].TryParse method instead.

HTH

[sknake]

Tq bro,

but still got problem...i cannot change or update that value in this textbox...anyone can guide me please...tq in advance

Is the textbox set ReadOnly = true or Enabled = false ?