Trim function problem in Access 2000 for reports and labels?

[Guest]

How can I resolve this issue. I tried to re-create the labels in 2000, but
for some reason, 2000 doesn't like the trim function that worked so well in
previous versions of Access

 

[Nick Coe \(UK\)]

Trim works OK for me in A2k. What do you mean by 're-create
labels'?

 

[Guest]

Have you put the following in the textbox of your report
=Trim([txtLabelName]) this works for me in Access 2000

 

[Guest]

Have you tryed to put =Trim([txtLabelName-1]) as the control source of your
textbox

 

[Dirk Goldgar]

How can I resolve this issue. I tried to re-create the labels in
2000, but for some reason, 2000 doesn't like the trim function that
worked so well in previous versions of Access

The Trim function is builtin to VBA, so you shouldn't have a problem
using it. However, if you have taken an existing database from an
earlier version and just opened it or converted it to Access 2000, you
may have a broken library reference that is keeping Access from
recognizing the VBA functions. See if Doug Steele's instructions at


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

help you resolve the problem.