If the values are stored as String, they are formatted using the
current locale. For example, pi is stored as 3.14159 in USA
and as 3,14159 in Italy. When you read this field, you have to
know which language was used to store it, otherwise you get
the wrong result.

If the original locale is English or any other that uses the
dot as decimal separator, you can use the Val() function to
convert a string into a number, because Val (as well as Str)
does not use the current locale format, but always the English
notation.

m.



-----Original Message-----
From: Bill [mailto:william.crawley@u...]
Sent: Tuesday, November 27, 2001 6:56 AM
To: professional vb
Subject: [pro_vb] Re: Fomatting between Uk and German


The field comes over from the database as a string although the value is a 
numeric. The fieldType on the Recordset is text.

Regards
Bill