leading zero's on a number

[clive2002]

I'm using an expression to show some text details and an autonumber with the "&".

The problem is i want some leading zeros in the autonumber to ensure overall format stays the same when the number grows in digits. I've tried changing the format for the autonumber but this doesn't change the actual value.

I want to get a result like "Record00001" or "Record00101"
But i'm getting "Record1" or Record101" at the moment.

In excel i'd use something like =text(autonumber field,"00000")

 

[RV]

This kinda topic is discussed many times.

Search the forums, I'm sure you'll find your answer

RV

 

[clive2002]

Thanks,

I eventualy found this and its just what i wanted.

Format(autonumber,"00000")