Problem with CHR function in VBA

[Matthew de Rouville]

I am having trouble getting the Chr function to work in Access 2000
(9.0.2720). I have VBA code with the Chr function. When I try to run it,
the function is highlighted in the VBA editor and the following message
comes up: "Compile Error. Can't find project or library."

The code works in Access 2002 (10.3409.3501) SP-1.

What I am trying to do is insert a carriage return and line feed in a memo
field. I am using chr(13) & chr(10), which works on the Access 2002
machine.

Any ideas? Thanks.

Matt

 

[Steve Schapel]

Matt,

This sounds like a References problem. Open any module in the VB
Editor window, select References from the Tools menu, and see if any
are marked MISSING:

For further information, see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

- Steve Schapel, Microsoft Access MVP

 

[Van T. Dinh]

Likely to be a Reference error.

See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Matthew de Rouville]

I found the references and saw several "Visual Basic for Application" ones;
I checked them all. I got an error message about a naming confict, but my
macro works. Thanks.