Format data....

[mfuada]

Hi..
i have textboxes in a form that look up its value to a listbox. and i have the code like this:
Private Sub List18_AfterUpdate()
series_fc = List18.Column(1)
maturity_fc = List18.Column(2)
coupon_fc = List18.Column(3)
face_value_fc = List18.Column(4)
End Sub
the problem is the format in the textbox doesn't match with the format on the listbox such as percent, in the listbox it shows 14,00% but in the textbox it shows 0.14....
i've changed the format in the textbox to percent but still hasn't got any change.. could anybody give me suggestion...
thx....

 

[Dennisk]

percent can be a bit strange to use as 60 formatted as a percent, is displayed as 600%.

percent is only used where the value is between 0 and 1 so .59 is 59%

 

[mfuada]

i think that the textbox can't be formatted.. because i've changed around the format a little bit in the textbox but still it has the same format value... and it's just not percent but the other valus also doesn't change like currency....
so is there a any idea?

 

[gemma-the-husky]

try something like

maturity_fc = format(List18.Column(2),"0.0%")

 

[mfuada]

it works perfectly.... thank you so much..