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!
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"
