Mask field to a specific lengh

[diacci1st]

HI All
I need to import a file with 3 field
Name/Surname/Cost centre and I need to fix the fields as
10/10/8 caracters so even after the data is uploaded the field will still be
that legh so I guess if my name was only 6 caracters access would add 4
spaces at the end to keep the 10 caracters.

How can I do it?

Thank you
AD

 

[Klatuu]

you can use an expression like this:

= [Name] & Space(10 - Len([Name]))

BTW, Name should not be used as a field name. Name is an Access reserved
word.