Currency Format

[DS]

I have an Unbound field that is formatted as Currency, however when I
place a number in it from another Unbound field which is also formatted
as Currency (This also doesn't show the dollar sign) The number is a
number with a decimal place but no dollar sign. How do I format this
field as Currency? I'm using a Popup form with a Number Pad to insert
the Numbers into the fields.
Thanks
DS

 

[Marshall Barton]

I have an Unbound field that is formatted as Currency, however when I
place a number in it from another Unbound field which is also formatted
as Currency (This also doesn't show the dollar sign) The number is a
number with a decimal place but no dollar sign. How do I format this
field as Currency? I'm using a Popup form with a Number Pad to insert
the Numbers into the fields.

Most likely, the number is being converted to a text string
somewhere along the way, probably by the popup form.

Add a CCur(...) to your code where you retrieve the value
from the popup form.

 

[DS]

DS wrote:





Most likely, the number is being converted to a text string
somewhere along the way, probably by the popup form.

Add a CCur(...) to your code where you retrieve the value
from the popup form.

Thanks
DS

 

[DS]

DS wrote:





Most likely, the number is being converted to a text string
somewhere along the way, probably by the popup form.

Add a CCur(...) to your code where you retrieve the value
from the popup form.

Thanks, I looked around. The value is being set from the Popup Form as
such....
Forms!Form!CurrencyField = Forms!Popup!Textbox

Where would I Place the CCur() ?
Thanks
DS

 

[Marshall Barton]

Thanks, I looked around. The value is being set from the Popup Form as
such....
Forms!Form!CurrencyField = Forms!Popup!Textbox

Where would I Place the CCur() ?

If I'm right about the cause of the problem, this shuld do
it:
Forms!Form!CurrencyField = CCur(Forms!Popup!Textbox)

 

[DS]

If I'm right about the cause of the problem, this shuld do
it:
Forms!Form!CurrencyField = CCur(Forms!Popup!Textbox)

Thank You...That worked!
DS