help with a text field

[Scootynm]

I have a text field where the records are currently 1...next record 2, next record 3....up to 953.

I am going to export this Access database to a dbf file. What I want is:

That field to be 5 characters long. and right justified. so the first entry would be four space2 and then 1, four spaces then 2....etc.

Is this possible? Thanks.

 

[WayneRyan]

Scootynm,

Update YourTable
Set    [YourField] = Space(5 - Len([YourField])) & [YourField]

Wayne

 

[Scootynm]

Thanks.

Worked great!