Update the data to be in certain digit form

[Nouri31]

Hi,



I have a series of data that start from 0 to 999. I have to save these data in text form in order to be able to update them to the form I need. I need these data to be in 3 digits vs number form. For instance, if the data is stored as 1, i want it to be updated it to 001. Is there any easy way to update the single digit and double digit numbers to be in the format mentioned above?

[June7]

The field must be set as text type for this update. Apply Format function. It is not necessary to actually change the value in table. A number data can be displayed on forms and reports with this structure using the Format function whenever needed.

Format([fieldname],"000")