Format Currency Problem

[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")

 

[boblarson]

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.

 

[Tom Wickerath]

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]

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)")

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
__________________________________________

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")

 

[Tom Wickerath]

<Smile>

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

 

[boblarson]

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.

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)")

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
__________________________________________

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")