OK, if your keypads have full stop and comma I can't easily test or suggest
from here. I suppose the only simple thing I would want to test is that
setting the language in the language bar didn't make any difference, but I
doubt if it will.
But if Word is receiving a "." when it needs a ",", the only suggestions I
can make are that you either move to using a VBA Userform or inputbox to
capture the data and transform it, or transform the "." into a "," inside
Word, or format your REF fields using a different technique. The only way I
can think of to do this using fields would be to use a DATABASE field which
may be overkill.
But if you want to try that, a way that should work in both Word 2000 and
later (though 2003 may create difficulties because of its pop-up messages
about SQL) would be the following:
Create a folder (say c:\d ) and an Access .mdb file in it (say d.mdb) with a
table in it (say "t") with a single text field "f" and a single row with "r"
in it. Let's suppose the bookmark your ASK field creates is called "X"
Insert the following nested field code and verify that it works:
{ DATABASE
\d "c:\\\d\\d.mdb"
\c "DSN=MS Access Database;DBQ=c:\\d\\d.mdb;"
\s "SELECT format('{ X }','#.,00 <euro symbol>') FROM `t`" }
There are a number of things to notice about this:
a. the { X } is a Word field, i.e. with the special field braces.
b. the single quotes around "t" in FROM `t` are backwards single quotes,
whereas the other ones are vertical single quotes '
c. the DSN name needs to match the one on your system, which may not use
the English name.
d. there is no \h - having only one column, one row, and no headers in the
result means Word inserts the result without wrapping it up in a table
e. you may to format the "D" of "DATABASE" with the format you need and add
a \*Charformat at the end
f. it seems to work with numbers containing either a . or a , but I suspect
inserting thousands separatos in the ASK field will cause problems.
g. "format" is quite versatile but is different in a number of ways from
the Word field equivalent. The position of the "." is important. Also, if
you want to use the full numeric format facilities (where you can have
formats 'a;b;c;d' for positive, negative, null and zero values) you will
probably need
"SELECT format(cdbl('{ X }'),'#.,00 <euro symbol>') FROM `t`"
h.You may need even more if you want to deal with invalid numbers, but I
leave that up to you.
I've checked this particular version in Word 2003 but not Word 2000 or Word
2002. In Word 2000 it used to be slightly simpler but I wasn't able to make
the old technique work in 2002/2003.
