Trim function in Access 2007 asking for parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.

Gene said:
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
 
Back
Top