$0.00 inserted into Currency field

[news.shaw.net]

I have a subform that contains a currency field.

If I tab my way to the field, everything works as desired, a number can
be entered, and when I leave the field it is rendered as a currency amount.

But if I click on the field with the mouse and enter a number, it shows
up like this: 250.00$0.00 with the $0.00 appended to what I type. I
have to delete it each time.

I've tried a few VBA OnEnter solutions, but nothing has worked so far.

Any suggestions?

Thanks,
Lester.

[Trevor Best]

Re: $0.00 inserted into Currency field

On Wed, 24 Dec 2003 00:02:30 GMT in comp.databases. ms-access,
"news.shaw. net" <adadf@null.net > wrote:
[color=blue]
>I have a subform that contains a currency field.
>
>If I tab my way to the field, everything works as desired, a number can
>be entered, and when I leave the field it is rendered as a currency amount.
>
>But if I click on the field with the mouse and enter a number, it shows
>up like this: 250.00$0.00 with the $0.00 appended to what I type. I
>have to delete it each time.
>
>I've tried a few VBA OnEnter solutions, but nothing has worked so far.
>
>Any suggestions?[/color]

Look at the Format property, is it set to something funny? If set to
"Currency" (or not set, in which case it will default to Currency)
then look at the currency format in your control panel.

I normally format currency fields as "Standard" in any case as I don't
want a specific currency symbol showing as I deal with multiple
currencies.

--
A)bort, R)etry, I)nfluence with large hammer.

[MGFoster]

Re: $0.00 inserted into Currency field

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In addition to what Trever Best says - you may have an Input Mask set
to $0.00. When you click directly IN the control the input mask
appears 'cuz Access thinks you are going to enter data. If you click
ON the control's LABEL (if it has one) the whole field can be
highlighted (if the options are correctly set) & you can delete the
highlighted portion by typing in the new data.

The highlighting of the value in a control is controlled by the Tools[color=blue]
> Options > Keboard tab > Behavior entering field > Select entire[/color]
field.

HTH,

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP+t2RYechKq OuFEgEQIZpwCfZ8 SHEix5HVGyH+Kwn 8+hjylDcCcAn1mp
n6vGi+svFO/b0jQ2t5EAiUha
=mJCI
-----END PGP SIGNATURE-----


news.shaw.net wrote:
[color=blue]
> I have a subform that contains a currency field.
>
> If I tab my way to the field, everything works as desired, a number can
> be entered, and when I leave the field it is rendered as a currency amount.
>
> But if I click on the field with the mouse and enter a number, it shows
> up like this: 250.00$0.00 with the $0.00 appended to what I type. I
> have to delete it each time.
>
> I've tried a few VBA OnEnter solutions, but nothing has worked so far.
>
> Any suggestions?
>
> Thanks,
> Lester.
>[/color]

[news.shaw.net]

Re: $0.00 inserted into Currency field

MGFoster wrote:[color=blue]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> In addition to what Trever Best says - you may have an Input Mask set
> to $0.00. When you click directly IN the control the input mask
> appears 'cuz Access thinks you are going to enter data. If you click
> ON the control's LABEL (if it has one) the whole field can be
> highlighted (if the options are correctly set) & you can delete the
> highlighted portion by typing in the new data.
>
> The highlighting of the value in a control is controlled by the Tools[color=green]
> > Options > Keboard tab > Behavior entering field > Select entire[/color]
> field.
>
> HTH,
>
> MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBP+t2RYechKq OuFEgEQIZpwCfZ8 SHEix5HVGyH+Kwn 8+hjylDcCcAn1mp
> n6vGi+svFO/b0jQ2t5EAiUha
> =mJCI
> -----END PGP SIGNATURE-----
>
>
> news.shaw.net wrote:
>[color=green]
>> I have a subform that contains a currency field.
>>
>> If I tab my way to the field, everything works as desired, a number
>> can be entered, and when I leave the field it is rendered as a
>> currency amount.
>>
>> But if I click on the field with the mouse and enter a number, it
>> shows up like this: 250.00$0.00 with the $0.00 appended to what I
>> type. I have to delete it each time.
>>
>> I've tried a few VBA OnEnter solutions, but nothing has worked so far.
>>
>> Any suggestions?
>>
>> Thanks,
>> Lester.
>>[/color]
>[/color]

Thanks,
This was what gave me the clue... The underlying linked table had a
default value set of 0 in that field. After clearing that everything is
OK. I was mucking around with the form and getting nowhere.

Thanks for your input.
Lester.