I have an Access 97 (yes, still) application which was developed on a Windows
NT machine. I've upgraded my development PC to Windows XP and now I'm getting
errors wherever the Format(), Left(), etc. functions appear in reports.

I'm sure I've had something very similar before (possibly with Excel) and
the solution was to clear and reinstate the VBA reference because it was
something to do with broken binary compatibility on the related DLL, but of
course Access 97 won't let you drop a built-in reference.

Can anyone please suggest a fix?

Common problem.

The issue is broken refs, you can find a soltion here:
Allen Browne
http://users.bigpond.net.au/abrowne1/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j....nceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html

Hey, Albert, the pigpond address doesn't work any more.
Best one to use is:
http://allenbrowne.com/ser-38.html

Do you have a permanent home for your Access stuff yet?

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

"Albert D. Kallal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Common problem.
>
> The issue is broken refs, you can find a soltion here:
> Allen Browne
> http://users.bigpond.net.au/abrowne1/ser-38.html

"Allen Browne" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hey, Albert, the pigpond address doesn't work any more.
> Best one to use is:
> http://allenbrowne.com/ser-38.html
>
> Do you have a permanent home for your Access stuff yet?

No, but am close to setting up my own server + permanent web address..


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal