How to not display leading zeros in text field?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
 
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

how can I trim leading zeros from a number in a text field for dis 4
Export of text field trims leading zeros 1
Restore leading zero 3
Leading Zeros 7
validation rule for exactly 5 digits, including leading zeros 0
Display Leading Zeros in Access 2
Summarize Records in Report 4
Add A Leading Zero 4

Back
Top