Using Trim (97/SR2)

Topic

New Reply

I am taking over the maintenance of a database. It is fairly straightforward, a membership database and was originally done in Access 2000. Since I don’t have 2000, the last administrator saved it as Access 97 and all seems to work fine…except for the TRIM function. In many of the reports and mailing labels, she had used trim, such as in the following:
=Trim([FirstName] & ” ” & [LastName])

When I try to run the report, I get a parameter query box asking for the Trim value. I don’t enter anything, (don’t know what to enter) then get errors in the report.

When I take out the word Trim from the expression, the report appears to run OK.

I know I have used Trim in Access 97, what could be causing the problem? Thanks for any help.

Reply | Quote

Replies

Don,

It sounds as though you have a missing reference.

To fix it, open some VBA Code. Open your references (Tools | References). Look for one that says it’s missing.

Note its name. Deselect it and close the References box.

Re-open the References box, and re-select the reference.

Close the box, and you should be back in business.

HTH,

Tom

Reply | Quote

Wow, that fixed it.

I say Wow, because I could have futzed around for a month and never, ever figured that one out. This is such a great resource, thanks to people like you, Tom. Thank you for your help.

Reply | Quote

Don,

You’re very kind. And very welcome.

More credit needs to go to the hosts/hostesses of this great forum. They keep a lot of us from .

Tom

Reply | Quote