Mask field to a specific lengh

  • Thread starter Thread starter diacci1st
  • Start date Start date
D

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
 
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.
 
Back
Top