Trim Function

[jack]

I have two a2000 vba projects, one can successfully call
the 'Trim' function, the other will only work if I use in
the following context: 'VBA.Trim'.

The code works, so no problem there, but why the
difference? I have checked the references, and both
include the vba library.

Small issue, but soooo annoying!

Regards

Jack

 

[Allen Browne]

Unless the database has a library marked "MISSING", it appears to believe
there is something else named "Trim". It could be an object, module, public
variable or even the project itself.

If you can't find any such object after a good search, you may be able to
straighten it out by declaring a public function named Trim in a new module.
Compile, and save. Delete the module. Compact the database. Compile again.
If you're in luck, Acces/VBA will have reassigned its Trim() to the new
function, and then freed it up when you deleted the module.