How to not display leading zeros in text field?

G

Guest

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?
 
G

Guest

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?
 
R

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export of text field trims leading zeros 1
Leading Zeros 7
Access 2003 - Joining number and text data 3
Restore leading zero 3
how can I trim leading zeros from a number in a text field for dis 4
Droping Leading Zeros In Table 4
Adding in leading zeros and a space to a text field in a table 4
Removing leading zeros 2

Top