supress leading zero

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I am looking for a way to supress leading zero.
I found ltrim or rtrim to supress leading and trailing spaces.


Are there similar functions to supress leading zeros?


Your information is great appreciated,
 
If your field is defined as a text field, that "0" is just another text
character.

If your field is defined as a number-type field, a "leading" zero is
meaningless, and may be due to the format property.

An example might help us understand your situation better...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.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

supress leading and tailing space 2
supress seconds for datetime 2
date time picker 1
Questions about formating Dates 8
Zero Supress 2
Outlook 16
Space 3
Supress Error Message Box 1

Back
Top