June 28, 200817 yr Hello and thanks in advance. I have a field (PurchaseMinimum)and I want to change the numbers to letters for security purposes. I have this code but I get an error that says I have too many separators... Any help is appreciated. Substitute (PurchaseMinimum,1,"L", PurchaseMinimum,2,"U", PurchaseMinimum,3,"B", PurchaseMinimum,4,"R", PurchaseMinimum,5,"I", PurchaseMinimum,6,"C", PurchaseMinimum,7,"A", PurchaseMinimum,8,"N", PurchaseMinimum,9,"T", PurchaseMinimum,0,"S" )
June 28, 200817 yr In version 4 you have to gang the Substitutes like this. Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute(PurchaseMinimum,1,"L"), 2,"U"), 3,"B"), 4,"R"), 5,"I"), 6,"C"), 7,"A"), 8,"N"), 9,"T"), 0,"S" )
Create an account or sign in to comment