No leading zero after update

[Ali Edwards]

Hi!!

I have 24 text boxes (OTDR Index1-24) on a form with default values of "01" to "24". Often however, the first of the boxes will need to be (say) "05" and I want the following boxes to auto fill incrementally after I have typed "05" in the first box. I have done this with a simple after update on the first box:
[OTDR Index2] = [OTDR Index1] + 1
[OTDR Index3] = [OTDR Index2] + 1

This works OK except I lose the leading zero in all but the first box and it is important that the numbers are "05", "06" etc not "5", "6".

I have tried number and data/text data types in the field. I have tried @@ as the format, nn as the format and I'm now lost!!

Help me if you can you lopvely people!

Many thanks

 

[ColinEssex]

Try

[OTDR Index2] = "0" & [OTDR Index1] + 1

etc.

Col

 

[Ali Edwards]

Oh so simple!! You are a genius. Thanks very much indeed.
Ali