How to not display leading zeros in text field?

[Linda Moore]

My text field has street names; some are words, some are numbers (ex: 6th
St). Numbered streets have from one to three digits. I use leading zeros to
get numbered streets to display in order. How can I get the leading zeros to
not display?

 

[RobFMS]

Linda

Can you give an example of how you store the street names? Is it in one
field? Do you put the numbered part of the address in a separate field?

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Linda Moore]

Rob, the number is not in a separate field. The reason is that the field
contains project titles, and sometimes the project starts with a street name
(ex.: 6th Street at Wilshire Widening). We have a protocol for naming
projects. Other names begin with words. So the numbered street is part of
the larger field. Currently, I use 3 digits (ex: 006th Street. . .) because
we have some 3-digit street names. Can I make the leading zeros not appear?

 

[RobFMS]

Linda

Follow this lead. This should help you out. I checked this via the immediate
window in Access.

? cint(left("006th North West",3)) & right("006th North West", len("006th
North West")-3)
6th North West

Let me know how it works out.
--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-