By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,444 Members | 3,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,444 IT Pros & Developers. It's quick & easy.

currency format in a textbox

P: n/a


Hi,

My db is stored in access and I have a field amount and its type is
currency.

When I read from the db and display it in a textbox, it shows me
15000000 instead of $150,000.00.

How can I do so it can shows me currency format?

Cheers!

Claudi

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Did you set the format of the control in your form to Currency? If you
do that you should be able to choose the formatting you want.

Nov 13 '05 #2

P: n/a

Already did, but nothing happens..

I'm using this sub procedure

Private Sub LoadControls(ByRef rs As ADODB.Recordset)
On Error Resume Next
If rs.EOF Or rs.BOF Then Exit Sub

amount = rs("amount")

Text4.Text = amount


Cheers!

Claudi

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

P: n/a
Try changing

Text4.Text = amount
to

Text4.Text = Format(amount,"$0,000.00")

"Claudia Fong" <cd********@yahoo.co.uk> wrote in message
news:2q*****************@news.uswest.net...


Hi,

My db is stored in access and I have a field amount and its type is
currency.

When I read from the db and display it in a textbox, it shows me
15000000 instead of $150,000.00.

How can I do so it can shows me currency format?

Cheers!

Claudi

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.