RE: Seting format to be 000000000000000

if the field is on a form and it is a text field that simply holds numbers
and the field length will always be 14 then you could put this in the after
update event of the field

YourField = Right("000000000000000" & [YourField],14)

"Beth" wrote:

> Hello Everyone,
>
> I have got a field called "amount".
>
> Currently it holds the following values 61025, 68653 etc
>
> Is there any built in function which I can use to fill the field with
> leading zeros?
>
> Eg so it displays 00000000061025, 00000000068653.
>
> Ideally I want to do this in a query without any manual steps as it will be
> run by end users.
>
> Kind Regards,
> Beth
.

Relevant Pages
Quantcast