How do I call this function?

[JPritch]

I did some searching and found this function posted by someone in response to the exact same problem I'm now encountering.

But how do I call this in my query?

Function StripZeros(pstr As String) As String
Dim n As Integer

n = 1
Do While Mid(pstr, n, 1) = "0"
n = n + 1
Loop
n = IIf(n > 1, n, 1)
StripZeros = Mid(pstr, n)

End Function

 

[WayneRyan]

JP,

Put the function in a Module on your Database window.

Make the function Public:

Public Function StripZeros(pstr As String) As String

Then, in a Query, add a new column:

NewField: StripZeros([pstr])

Then use NewField in any form, report or whatever.

Wayne

 

[JPritch]

Thanks Wayne, works like a charm~!