Perfect! Thank you!. This is what Ive made:
Code:
Public Function PhoneTrim (TrimTxt as string)
Trimtxt = Replace (trimtxt, “-”, “”)
Trimtxt = Replace (trimtxt, “(”, “”)
Trimtxt = Replace (trimtxt, “)”, “”)
Trimtxt = Replace (trimtxt, “_”, “”)
Trimtxt = Replace (trimtxt, “ ”, “”)
Trimtxt = Replace (trimtxt, “+”, “”)
Trimtxt = Replace (trimtxt, “*”, “”)
PhoneTrim= TrimTxt
End Function
This is one of the first codes Ive made. You say I can call the function from a query so long as its in a module. But how do I run it from a module? I have never done that before.