EUROCONVERT Trouble

I have tried to use the EUROCONVERT Function to convert £ to Euro's but it
keeps coming up with "Subscript out of range". How do I correct this problem?
I am putting it in a Label DblClick procedure to convert the amount in a
Text Box. I am using a Varient Variable, which has the value of the Text Box,
as the number argument. The source currency is GBP and the target currency is
EUR.
It is written as EuroConvert(variable name, "GBP", "EUR") as shown in the
Microsoft Help. Do I need to ad anyting else to it?

Hi Jim,

EuroConvert() only converts the former national currencies of the euro
zone, using the EU's official fixed exchange rates. AIUI the idea was to
simplify conversions during the transitional period and historical
comparisons thereafter. So it doesn't recognise "GBP". Presumably the
function will be updated if and when other member states commit to fixed
exchange rates and the euro.

To convert between GBP and EUR you'll need to provide an appropriate
exchange rate yourself (current or for the date in question). I'm sure
there are web services that offer this but have no experience of using
them; for manual look-ups of exchange rates I usually use www.oanda.com.

On Fri, 8 Apr 2005 14:09:03 -0700, pompeyjim
wrote:

I have tried to use the EUROCONVERT Function to convert £ to Euro's but it
keeps coming up with "Subscript out of range". How do I correct this problem?
I am putting it in a Label DblClick procedure to convert the amount in a
Text Box. I am using a Varient Variable, which has the value of the Text Box,
as the number argument. The source currency is GBP and the target currency is
EUR.
It is written as EuroConvert(variable name, "GBP", "EUR") as shown in the
Microsoft Help. Do I need to ad anyting else to it?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

"pompeyjim" wrote:

Thanks John. Looks like I'll have to stick to manually doing it (or at least
my client will).