supress leading zero

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,
 
J

Jeff Boyce

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
Questions about formating Dates 8
date time picker 1
Space 3
Do I have to worry about Access storing Trailing or leading spaces 5
Database syntax error 2
Outlook 16

Top