ARGGHH! Error with Runtime Version of Access 2000

[Dr. Know]

I have an application that works perfectly under the full install of
Access 2000, but when deployed with the runtime version, I get an
error:

2147217900, formatcurrency function not defined.

The formatcurrency() function is used in the select clause of an SQL
query.

I have searched both MS and MSDN CD's with no results.
Does anyone know what on earth is going on here?

Target has Jet SP8, and MDAC 2.6.

Thoroughly Confused....
Greg

















Dr. Know

 

[Allen Browne]

Some functions are not supported in expressions of a query, according to
this article from Microsoft::
Cannot Use New Visual Basic for Application Functions as Expressions
at:
http://support.microsoft.com/?id=225956

As a workaround, try:
Format([MyField], "Currency")
or if you want the value as a number:
CCur()

 

[Dr. Know]

Allen Browne said:

Some functions are not supported in expressions of a query, according to
this article from Microsoft::
Cannot Use New Visual Basic for Application Functions as Expressions
at:
http://support.microsoft.com/?id=225956

Thanks for the info, works fine with the standard format function.

I still wonder why it works on the standard Office install, but not
with Runtime? Oh, well... The Formatxxx functions have just been
blackballed...

Thanks,
Greg








Dr. Know

 

[david epsom dot com dot au]

I think you don't have all the service packs installed
on the runtime version....

(david)