Trim function in Access 2007 asking for parameter

[Guest]

I have just upgraded to Access 2007 from Access 2000 and a report that I have
for generating labels uses the Trim function. When I run the report I get a
parameter prompt. I also saw an earlier (18 months ago) question where
someone had a similar problem going to Access 2003 from Access 2000 but since
the menus are different I was not able to translate the response to Access
2007. It referred to reference problems in that earlier answer.

 

[HiTechCoach via AccessMonster.com]

A common cause for the common function like TRIM to stop working is due to
missing reference lib's. I would recommend checking for missing references.

I have just upgraded to Access 2007 from Access 2000 and a report that I have
for generating labels uses the Trim function. When I run the report I get a
parameter prompt. I also saw an earlier (18 months ago) question where
someone had a similar problem going to Access 2003 from Access 2000 but since
the menus are different I was not able to translate the response to Access
2007. It referred to reference problems in that earlier answer.

--
Boyd
Hi Tech Coach
http://www.hitechcoach.com

Message posted via AccessMonster.com

 

[Craig]

Where do you check for missing reference lib's at?

Craig