Passing "@" symbol in UDF parameter

  • Thread starter Thread starter Reid Kell
  • Start date Start date
R

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.
 
Back
Top