Format Currency Problem

  • Thread starter Thread starter Bob V
  • Start date Start date
B

Bob V

I have not got this Format Currency quite right But I must be close??
Thanks for any help....Bob

[tbClientName] = Me.cbOwnerName.Column(3)
[tbAmount] = Me.cbOwnerName.Column(6) = Format(tbAmount, "#0.00")
 
Have you tried:

tbAmount] = Me.cbOwnerName.Column(6) = Format(tbAmount, "Currency")


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
Brilliant Tom,BRILLIANT Sorry didn't want to make it to easy for you,
lol......Bob
[tbAmount] = Format(Me.cbOwnerName.Column(6), "$#,##0.00;($#,##0.00)")

Tom Wickerath said:
Hi Bob,

Perhaps this:

[tbAmount] = Format(Me.cbOwnerName.Column(6), "#0.00")

but it's really hard to say, becuase you haven't really explained, in
words,
what it is that you are needing to do.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Bob V said:
I have not got this Format Currency quite right But I must be close??
Thanks for any help....Bob

[tbClientName] = Me.cbOwnerName.Column(3)
[tbAmount] = Me.cbOwnerName.Column(6) = Format(tbAmount, "#0.00")
Click to expand...
Click to expand...
 
I was serious though - as this works for me:

tbAmount] = Me.cbOwnerName.Column(6) = Format(tbAmount, "Currency")
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.


Bob V said:
Brilliant Tom,BRILLIANT Sorry didn't want to make it to easy for you,
lol......Bob
[tbAmount] = Format(Me.cbOwnerName.Column(6), "$#,##0.00;($#,##0.00)")

Tom Wickerath said:
Hi Bob,

Perhaps this:

[tbAmount] = Format(Me.cbOwnerName.Column(6), "#0.00")

but it's really hard to say, becuase you haven't really explained, in
words,
what it is that you are needing to do.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Bob V said:
I have not got this Format Currency quite right But I must be close??
Thanks for any help....Bob

[tbClientName] = Me.cbOwnerName.Column(3)
[tbAmount] = Me.cbOwnerName.Column(6) = Format(tbAmount, "#0.00")
Click to expand...
Click to expand...
Click to expand...
 
Back
Top