Right Justify And Zero Fill

[Gary Wilson]

I have a text field that has a field size of 11. The values in this field
vary from 0 to 7 characters. I need to export this field to a text file and
the entire field MUST be used. For example, if the field has a value of
123456, then the exported field needs to have a value of 00000123456 (with
the value to the right).

Is there a way to do this?

 

[Jeff Boyce]

Gary

Take a look at using the Format() function in a query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

You can use Right("00000000000" & [YourField], 11)