Format Function in a Query

[nikdiva]

Hi All:
I am trying to figure out the problem with the following function used in a update query:

Format([RecID],'000000')

I think what the programmer was trying to do (wasn't me) is format the number as 6 digits so that it could be like "000010" etc.

What is wrong with this picture?

Nikki

 

[gol4]

Not too much except needs double quotes

?format(12345,"000000&quot
0012345
?format(1234,'000000')
produces error expected expression