leading zero's on a number (1 Viewer)

[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")

 

[Pat Hartman]

Clive, for future reference, please don't post the same question multiple times. I just answered your question in the general forum and since it wasn't as detailed as this question, I had to look up the Test() function in Excel to find out what you were trying to do. I really don't have the time to waste answering questions that others or yourself have already answered and that is exactly what happens when you double post.