See the numbers in a cell and if it's less then five chars convert...

[Gti]

I have a cell that should be field with five chars, but my problem is that when the user just insert less chars than five i need to put the missed char as 0!
How can i do this?
How can i run all cells in a table?

 

[JoeMiller]

In the BeforeUpdate event, place code to inspect the control and modify the data if it's less than 5 digits in length:

If Len(MyControl)<5 Then
MyControl = Format(MyControl,&quot;00000&quot
End If

HTH Joe Miller
joe.miller@flotech.net