带有外语数字字段的MS Access数据库 [英] MS Access Database with number fields in a foreign language

问题描述

我有一个MS Access 2007数据库.我在哥伦比亚和厄瓜多尔的一些客户遇到了一个问题(并且我肯定会弹出更多问题)，这些客户的编号格式与美国不同.他们使用".小数点(或句号)字符作为其百万和千位分隔符，小数点后使用，"逗号.尽管我只使用IsNumeric()函数检查字段内容，但这可能导致类型不匹配错误，或者我自己的验证将其捕获为错误.

I have a MS Access 2007 database. I have run into an issue (and I'm sure more will pop up) with some clients in Columbia and Ecuador where their numbering format is different than the U.S. They use a "." decimal point (or period) character for their Millions and Thousands separator and use a "," comma character for the decimal place. This either causes a type mismatch error, or my own validation catches it as an error, although I'm only using the IsNumeric() function to check the field contents.

我认为MS Access可以识别用户Windows设置中设置的任何区域键盘格式.

I would assume MS Access would recognize whichever regional keyboard format is set up in the users Windows settings.

有人可以帮我阐明一下吗?到目前为止，唯一的解决方法是更改​​用户的键盘设置，以将，"用于成千上万的分隔符和".十进制.

Can anyone shed some light on this for me? As of right now, the only fix is to change the users keyboard settings to use a "," for the millions and thousands separator and a "." for a decimal.

任何帮助将不胜感激！ :-)

Any help would be greatly appreciated! :-)

推荐答案

这应由本地PC上的语言环境设置控制.您可以设置小数点分隔符和数字分组分隔符，然后Access在其他语言环境中以与1,000.21相同的方式与1.000,21进行交互.

This should be controlled by the locale settings on the local PC. You can set the decimal separator and number grouping separator, and then Access interacts with 1.000,21 in the same way as 1,000.21 in other locales.

?Format(1000,"currency")
€1.000,00

这篇关于带有外语数字字段的MS Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！