TYPE MISMATCH

I have a field where the format is set to currency, However I want to
use a Calculator type Number Pad to Enter the Dollar Amounts in gthe
field. I have this part figured out but I keep getting a Type Mismatch
Error. Any suggestions? Thanks.
DS

re: TYPE MISMATCH

DS wrote:
[color=blue]
> I have a field where the format is set to currency, However I want to
> use a Calculator type Number Pad to Enter the Dollar Amounts in gthe
> field. I have this part figured out but I keep getting a Type Mismatch
> Error. Any suggestions? Thanks.
> DS[/color]

Let's say you have a line like
curVal = Calculator()
msgbox curVal

What is the value that is being returned from Calculator?

re: TYPE MISMATCH

Salad wrote:[color=blue]
> DS wrote:
>[color=green]
>> I have a field where the format is set to currency, However I want to
>> use a Calculator type Number Pad to Enter the Dollar Amounts in gthe
>> field. I have this part figured out but I keep getting a Type
>> Mismatch Error. Any suggestions? Thanks.
>> DS[/color]
>
>
> Let's say you have a line like
> curVal = Calculator()
> msgbox curVal
>
> What is the value that is being returned from Calculator?
>[/color]
Format(0,"0.#")

re: TYPE MISMATCH

DS wrote:
[color=blue]
> Salad wrote:
>[color=green]
>> DS wrote:
>>[color=darkred]
>>> I have a field where the format is set to currency, However I want to
>>> use a Calculator type Number Pad to Enter the Dollar Amounts in gthe
>>> field. I have this part figured out but I keep getting a Type
>>> Mismatch Error. Any suggestions? Thanks.
>>> DS[/color]
>>
>>
>>
>> Let's say you have a line like
>> curVal = Calculator()
>> msgbox curVal
>>
>> What is the value that is being returned from Calculator?
>>[/color]
> Format(0,"0.#")[/color]

Format is a string. Are you then storing it to a Currency field?

re: TYPE MISMATCH

DS wrote:
[color=blue]
> Salad wrote:
>[color=green]
>> DS wrote:
>>[color=darkred]
>>> I have a field where the format is set to currency, However I want to
>>> use a Calculator type Number Pad to Enter the Dollar Amounts in gthe
>>> field. I have this part figured out but I keep getting a Type
>>> Mismatch Error. Any suggestions? Thanks.
>>> DS[/color]
>>
>>
>>
>> Let's say you have a line like
>> curVal = Calculator()
>> msgbox curVal
>>
>> What is the value that is being returned from Calculator?
>>[/color]
> Format(0,"0.#")[/color]
Got it Working, Thanks.
DS