The value you entered isn't valid for this field

[Stapes]

Hi

I keep getting this irritating useless error message: -

The value you entered isn't valid for this field

For example, you may have entered text in a numeric field or a number
that is larger than the FieldSize setting permits.

Useless because it doesn't tell you which field!
I have tracked it down however. I have tried various different
settings for this field. In the table - Data Type: Number. Format
Single. Decimal Places (I have tried auto and 2)
I actually want currency, but I can't use currency because I want to
use 5 or more currencies, not just pounds, so I don't want the pound
sign all over the place.
Anyway, I keep typing in a number, such as 50 - which is definitely a
number, and keep getting this error. What is going on?

Stapes

 

[fredg]

Hi

I keep getting this irritating useless error message: -

The value you entered isn't valid for this field

For example, you may have entered text in a numeric field or a number
that is larger than the FieldSize setting permits.

Useless because it doesn't tell you which field!
I have tracked it down however. I have tried various different
settings for this field. In the table - Data Type: Number. Format
Single. Decimal Places (I have tried auto and 2)
I actually want currency, but I can't use currency because I want to
use 5 or more currencies, not just pounds, so I don't want the pound
sign all over the place.
Anyway, I keep typing in a number, such as 50 - which is definitely a
number, and keep getting this error. What is going on?

Stapes

Regarding: < I actually want currency, but I can't use currency
because I want to use 5 or more currencies, not just pounds, so I
don't want the pound sign all over the place.>

You are confusing the field Datatype property of "Currency" with the
field Format property of "Currency". They are different.

If you wish the datatype of currency (accurate decimal computation up
to 4 places) you can set the Format property to any number format,
such as Fixed 2 decimal places (or set the Format property to
#,###.00
which will show the value with comma separated thousands,
i.e.1,234.00). Try it.
No pound sign unless you use Currency Format.

 

[Guest]

Hi Stapes,

To add a little to Fred's answer:

Regarding: < I actually want currency, but I can't use currency
because I want to use 5 or more currencies, not just pounds, so I
don't want the pound sign all over the place.>

Try this method that I posted earlier:

http://groups.google.com/group/micr..._frm/thread/2323ff20e17158fe/63601a889838665e



Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Jamie Collins]

Try this method that I posted earlier:

http://groups.google.com/group/microsoft.public.access.modulesdaovba/...

Agreed, a table of ISO 4217 three letter currency codes is a good
approach.

I also agree with the OP that CURRENCY is unsatisfactory because the
implicit behaviour where the currency format from Regional Settings is
assumed.

The floating point (approximate) data types, Single and Double, are
most inappropriate for money data and should be avoided in favour of a
fixed point (exact) type, either CURRENCY or, my personal preference,
DECIMAL.

Jamie.

--

 

[Jamie Collins]

Agreed, a table of ISO 4217 three letter currency codes is good.

You should, of course, use the ISO 3166-1 three letter country codes!

Jamie.

--

 

[Guest]

Jamie,

You should, of course, use the ISO 3166-1 three letter country codes!

Why? Perhaps you'd like to enlighten us on what the differences are between
ISO 3166-1 and ISO 4217. I honestly haven't got a clue, and I'm not all that
inclined to want to go looking at 1:30 in the morning. If you feel ISO
3166-1 is better, then say why you think this is so, and perhaps provide a
link to a site with ISO 3166-1 country codes.

G'night.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Jamie Collins]

Perhaps you'd like to enlighten us on what the differences are between
ISO 3166-1 and ISO 4217.

ISO 3166-1 are country codes and ISO 4217 are currency codes.

If you feel ISO
3166-1 is better, then say why you think this is so

You provided a good example yourself i.e. why try to decide whether to
store 'UK' or 'Britain' or 'The United Kingdom of Great Britain and
Northern Ireland' (or all of them and only later discover they are
duplicates) when you can simply store 'GBR' in a CHAR(3) column? The
ISO have change control mechanisms.

perhaps provide a
link to a site with ISO 3166-1 country codes.

Currency codes:
The trusted source of course the ISO and the currency codes are freely
available:

http://www.iso.org/iso/en/prods-services/popstds/currencycodeslist.html

The wikipedia entry documents many of the historical codes:

http://en.wikipedia.org/wiki/ISO_currency_codes

Country codes:
The ISO codes must be purchased using CHF's (http://www.iso.org/iso/en/
prods-services/iso3166ma/05database/index.html) but are widely
available e.g. wikipedia:

http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3

Jamie.

--

 

[Guest]

Hi Jamie,

Thanks for the additional information and links.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________