number Format

[mr moe]

I have a field that is formated to 6 digits length example 123456 some numbers in the table are five digits length example 12345, how can I make 12345 look like 012345 my idea is to insert a zero for all numbers that are five digits length, but I need to do this in VB anybody can help. Thanks guys.

 

[Mile-O]

Format(YourNumber, "000000")

 

[mr moe]

Thanks for the fast reply.
I tried that but its still not working. Here is the way I have done it.
myfieldname = format(myfieldname,"000000")
This is still displaying it as for ex 12345 and not 012345. What do you suggest?

 

[crosmill]

If LEN([Field]) = 5 then
[Field] = '0' & [Field]
end if

nb field type must be a string

 

[Mile-O]

nb field type must be a string

You can factor that in:

If Len(CStr([Field])) = 5 Then
    [Field] = "0" & [Field]
End If

 

[mr moe]

Thanks guys, it worked.