469,904 Members | 2,048 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,904 developers. It's quick & easy.

$0.00 inserted into Currency field

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.

Nov 12 '05 #1
3 2716
On Wed, 24 Dec 2003 00:02:30 GMT in comp.databases.ms-access,
"news.shaw.net" <ad***@null.net> wrote:
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?


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.
Nov 12 '05 #2
-----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
Options > Keboard tab > Behavior entering field > Select entire field.

HTH,

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

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

iQA/AwUBP+t2RYechKqOuFEgEQIZpwCfZ8SHEix5HVGyH+Kwn8+hjy lDcCcAn1mp
n6vGi+svFO/b0jQ2t5EAiUha
=mJCI
-----END PGP SIGNATURE-----
news.shaw.net wrote:
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.


Nov 12 '05 #3
MGFoster wrote:
-----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
> Options > Keboard tab > Behavior entering field > Select entire

field.

HTH,

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

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

iQA/AwUBP+t2RYechKqOuFEgEQIZpwCfZ8SHEix5HVGyH+Kwn8+hjy lDcCcAn1mp
n6vGi+svFO/b0jQ2t5EAiUha
=mJCI
-----END PGP SIGNATURE-----
news.shaw.net wrote:
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.


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.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by John L | last post: by
1 post views Thread by Brandon McCombs | last post: by
2 posts views Thread by Dalan | last post: by
3 posts views Thread by Dalan | last post: by
3 posts views Thread by Melissa | last post: by
2 posts views Thread by DD | last post: by
3 posts views Thread by Dave Stone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.