Functions in Access 2003

  • Thread starter Thread starter David Harris
  • Start date Start date
D

David Harris

Hi everybody!

I've got a n access 2003 report that uses Mid to trim the leading zero of
telephone numbers before printing them. in Xp/2002 it worked fine but now it
doesn't - nor do any functions for that matter (Left, Right, substring etc).

the code that used to work is a sfollows:
=IIf(IsNull([central_tel]),"-",IIf([country_ID]="239","00" & [country_DCode]
& " " & [central_tel],"00" & [country_DCode] & " " & Mid([central_tel],2)))
When run an input box pops up asking me to enter the parameter value.

If I take the Mid function out ath the end it will produce a form without
errors.
Anybody have any ideas?

Thank

David
 
David said:
I've got a n access 2003 report that uses Mid to trim the leading zero of
telephone numbers before printing them. in Xp/2002 it worked fine but now it
doesn't - nor do any functions for that matter (Left, Right, substring etc).

the code that used to work is a sfollows:
=IIf(IsNull([central_tel]),"-",IIf([country_ID]="239","00" & [country_DCode]
& " " & [central_tel],"00" & [country_DCode] & " " & Mid([central_tel],2)))
When run an input box pops up asking me to enter the parameter value.

If I take the Mid function out ath the end it will produce a form without
errors.
Click to expand...


That sounds like a library referencing problem. Check here
for an aricle on the issues:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 
Back
Top