Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Using Trim (97/SR2)

    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.

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Trim (97/SR2)

    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

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Using Trim (97/SR2)

    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.

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Trim (97/SR2)

    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 <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>.

    Tom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •