Use of FormatCurrency() in Report Causes User Prompt

[Barbara T]

In my Access 2000 report, I have a user-defined function
that includes returning a domain aggregate value (DSum),
and then, if the value is is not null or an empty string,
formats the result as currency using the "FormatCurrency
()" function.

In my test environment (Windows 2K, Office 2K with SP3),
the report is operating just fine. In my customer's
environment, they get a prompt for FormatCurrency. VB for
applications is in the Project References. The Access
application is installed on a Citrix server (Win2K, Office
2K). Could there be some sort of permissions issue such
that VB for Applications is not accessible to the Access
application? Or could this be related to Knowledgebase
article indicating that certain VB functions can't be used
as an expression?

Any assistance gratefully appreciated.

 

[Van T. Dinh]

It sounds more likely to be References problems on the
Citrix Server. See Douglas J. Steele's article:

<http://members.rogers.com/douglas.j.steele/AccessReference
Errors.html>

HTH
Van T. Dinh
MVP (Access)