In general, macros are not adequate for this kind of thing, but you may be
able to get IsError() to tell you if the expression returns an Error.

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps.org.
> In a Macro how do you phrase the condition to equal on #Error in a certain
> field?
> Thanks
> DS