Work with XP but not 2000? Access 2000

[N. Graves]

I'm using the replace function in an unbound text field to clean up
some data. I have Access 2000 on both an XP and 2000 machines. When
I use this DB on an XP machine works great last a long time.... When
I put it one a 2000 machine the field display #Name? instead of the
data and when I go to Properties/Control source I get an error "The
object doesn't contain the Automation object 'Replace."
Here is the value of Control Source
"=IIf([AreaCode]<>"",Replace([AreaCode],"~"," "),[AreaCode])"
Is there something else I can do to achieve this same result or
something I can turn on to allow this to work on 2000 box

[Allen Browne]

Yes, A2000 only partially implemented the functions listed below. They seem
to work on some computers, but not others, and the workaround is to create a
VBA wrapper for each function you need to use, and call that instead.
Unfortunately, a VBA function runs *really* slowly in queries in later
versions, so you kinda can't win here.

See knowledgebase article:
http://support.microsoft.com/?id=225956

Affected functions:
FormatCurrency(), FormatDateTime(), FormatNumber(), FormatPercent(),
InStrRev(), MonthName(), Replace(), Round(), StrReverse() and WeekdayName()

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:pf********************************@4ax.com...

I'm using the replace function in an unbound text field to clean up
some data. I have Access 2000 on both an XP and 2000 machines. When
I use this DB on an XP machine works great last a long time.... When
I put it one a 2000 machine the field display #Name? instead of the
data and when I go to Properties/Control source I get an error "The
object doesn't contain the Automation object 'Replace."
Here is the value of Control Source
"=IIf([AreaCode]<>"",Replace([AreaCode],"~"," "),[AreaCode])"
Is there something else I can do to achieve this same result or
something I can turn on to allow this to work on 2000 box

[david epsom dot com dot au]

> something I can turn on to allow this to work on 2000 box

Yes, you need to apply all Office and Jet service packs to the
Office 2000 box, and you may need to check the references in
the VBA Project of the database.

If you are using Access 2000, you must in any case use at least
SR1 for Office 2000, so this is something you need to check anyway.

(david)
"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:pf********************************@4ax.com...

I'm using the replace function in an unbound text field to clean up
some data. I have Access 2000 on both an XP and 2000 machines. When
I use this DB on an XP machine works great last a long time.... When
I put it one a 2000 machine the field display #Name? instead of the
data and when I go to Properties/Control source I get an error "The
object doesn't contain the Automation object 'Replace."
Here is the value of Control Source
"=IIf([AreaCode]<>"",Replace([AreaCode],"~"," "),[AreaCode])"
Is there something else I can do to achieve this same result or
something I can turn on to allow this to work on 2000 box