Formatting Zip Code

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

Guest

Folks,

I am using this expression (that one of you helped me with a while back).

CorrectZip: IIf([Zip] Like "#####-",Left([Zip],Len([Zip])-1),IIf([Zip] Like
"#########",Format([Zip],"@@@@@-@@@@"),[Zip]))

All of a sudden (and not in the old databases I am using this in) I am
getting the following message:

Undefined function 'Left' in expression

Thanks for your help.
 
You probably have a Missing reference. Open the Code window (Ctrl + G).
Select Tools > References. If any are marked as Missing, remove the
checkmark, close the window, reopen the window and recheck the reference. It
should reset the link to the library.
 
Back
Top