How can I remove leading zeros?

From: AccessHelp <AccessHelp@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 26 Sep 2007 13:58:00 -0700

Hello,

I have a field with values "AAAA", "0AAA", "00AA", and "000A". I want to
remove leading zeros on the ones with leading zeros. For example, "0AAA"
will turn into "AAA".

Can someone help me with the formula? I have tried using "Val" and "Str",
and they don't seem to work.

Thanks.
.

Follow-Ups:
- Re: How can I remove leading zeros?
  - From: Gary Keramidas

Prev by Date: Beforesave - Save copy on my desktop
Next by Date: Re: button macro
Previous by thread: Beforesave - Save copy on my desktop
Next by thread: Re: How can I remove leading zeros?
Index(es):
- Date
- Thread