[AccessD] 2000 vs 97 - trim error

Kathryn Bassett kathryn at bassett.net
Sat Mar 12 16:48:27 CST 2005


Friend has Access97, and the data she's been using for a couple years now has been working fine. She received a new grouping of people, so I brought her 97 home, opened with 2k, imported and set up the new table (members), made a query and set up one of the reports. Everything working fine in 2k. Did the save to previous version, went to her house and put back on computer. Queries and forms work fine, but when I tried to do reports, the all give me this trim error.
http://www.ourwebsite.org/storage/misc/trimerror1.jpg and here is what the design view looks like
http://www.ourwebsite.org/storage/misc/trimerror2.jpg

All the reports are similar, and give the same error, even though I never touched them. So it must be something about taking from 97 to 2k and back again that messed things up. What's wrong and how do I fix?

If you need to see the actual mdb, I've zipped both versions and put them here:
http://www.ourwebsite.org/storage/misc/pgch.zip 

Thanks,

--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net   




More information about the AccessD mailing list