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/
 
Back
Top