Input mask LLL000 on PK to assist with validationInport the raw text data and although there are mistakesin the PK data e.g. LLLLLLL, it still inports all the data.If I then key in a new record, the input mask kicks in?How can I ensure when inporting raw data that the correct info is being inported, if the input mask doesn't work all the time?1 person needs an answerI do too

Try one of the Access Newsgroups -Microsoft Office Newsgroups:-http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx#9 Access Database General Questions New Users Database Design Forms Forms Coding Import/Export Data Install and Configure Macros Programming Queries Reports Security TaurArian [MVP] 2005-2010 - Update Services