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

 

[Tom Wickerath]

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
__________________________________________

 

[Tom Wickerath]

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
__________________________________________

 

[Tom Wickerath]

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
__________________________________________