Passing "@" symbol in UDF parameter

[Reid Kell]

I have a UDF with three parameters, the last of which is an email address.
The function works fine in query analyzer. However, when using the following
statement in my Access 2003 ADP's report recordsource...

SELECT * FROM udf_GetUserInfo (Null, Null, '(e-mail address removed)')

I get "Jet error 3: Closing delimiter not found at position xx..." and so
forth and the process fails. It works/worked fine in Access 2000. How can I
pass the "@" symbol in a UDF parameter in Access 2003? Thanks.

 

[Igor V. Makeev]

Hello, Reid!
You wrote in message on Wed, 18 Aug 2004 17:03:40 -0700:

RK> How can I pass the "@" symbol in a UDF parameter in Access 2003?

http://support.microsoft.com/default.aspx?scid=kb;en-us;287454

With best regards, Igor.
ICQ: 111469481