Currency Format

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
DS said:
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.
Click to expand...


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.
 
Marshall said:
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.
Click to expand...
Thanks
DS
 
Marshall said:
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.
Click to expand...
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
 
DS said:
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() ?
Click to expand...


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