Access "Anti trim"

I have a local table where I am needing to change the primary key so it formatted the same way that a field is in a separate linked table.



In the linked table, the field is formatted to always be 10 characters. There is always a space at the end which is included in those 10 characters. In positions without a character, there is a space.



EX:

800= “(space)(space)(space)(space)(space)(space)800(spa ce)”

10155= “(space)(space)(space)(space)10155(space)”



In my local table, the field is trimmed.



EX:

800= “800”

10155= “10155”



This expression gives me the correct number of characters with a space at the end, but I need the zeros to be spaces instead of zeros.



Expression: Format([field],"000000000" & " ")



These fields are text fields and must stay that way. Any ideas?? Thank you!

Access "Anti trim"