Function SUBSTITUTE not available. When I run
Zip = Substitute("2003 Budget", "2003", "2004"), I get error message saying
that Function not defined. Why?

There's no function by that name built into any version of Access with which
I'm familiar.

Perhaps you mean the Replace function?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Mark R. Rutter" <(E-Mail Removed)> wrote in message
news:06B49D9D-7A5F-4FEF-B414-(E-Mail Removed)...
> Function SUBSTITUTE not available. When I run
> Zip = Substitute("2003 Budget", "2003", "2004"), I get error message
> saying
> that Function not defined. Why?

I found the answer.
SUBSTITUTE is a worksheet function with no equivalent VBA function. To use
the worksheet function in VBA, the code looks like,
Zip = WorksheetFunction.Substitute("2003 Budget", "2003", "2004").

The same applies to worksheet functions FIND and SEARCH

"Mark R. Rutter" wrote:

> Function SUBSTITUTE not available. When I run
> Zip = Substitute("2003 Budget", "2003", "2004"), I get error message saying
> that Function not defined. Why?