TYPE MISMATCH

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 03 Nov 2004 18:26 GMT

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

Reply to this Message

Salad - 03 Nov 2004 19:38 GMT

> 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

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

What is the value that is being returned from Calculator?

Reply to this Message

DS - 03 Nov 2004 19:59 GMT

>> 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
[quoted text clipped - 7 lines]
>
> What is the value that is being returned from Calculator?

Format(0,"0.#")

Reply to this Message

Salad - 03 Nov 2004 20:05 GMT

>>> 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
[quoted text clipped - 9 lines]
>>
> Format(0,"0.#")

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

Reply to this Message

DS - 04 Nov 2004 15:43 GMT

>>> 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
[quoted text clipped - 9 lines]
>>
> Format(0,"0.#")

Got it Working, Thanks.
DS

Reply to this Message