data format problem from access through vb6
Posted on 2009-04-06
i am using vb6 with ms acces 2003. i have a field in database with data type "NUMBER" format "CURRENCY" and decimal places "3". in access data is shown with currency symbol and with accurate decimal places.
Problem is , when i try to show the data in a textbox, it just truncate the last zero.
suppose if amount is "23.230" , it shows "23.23".
i have set the data formate property of text box to "CURRENCY".
I CHECKED by putting beak point where recoredset is assigining value to textbox like this
textbox1.text=rs![myamount], it is showing value "23.23" over there as well.
so may be its record set problem or text box.
could please any body guide me for this.
thanks and regards.