I'm using an Access 2003 database to store a WBS number in a table. I have a mask set up in the table design to restrict the format of the WBS. The data is 1234-12-1234-123456. The mask is AAAA\-AA\-AAAA\-AAAAAA;0;_ and the field is set to text, and the mask is supposed to store the "-" in the field. I use a form to enter the data, and the form has the same mask set up.
I use a split frontend and backend, with data being entered from 2 locations (to the same table) about 200 miles apart.
about 5% of the entries end up being stored without the "-" causing difficulties in generat1ng reports.
Any assistance in getting the table to store the data in the correct format would be appreciated.
---
Tom
I use a split frontend and backend, with data being entered from 2 locations (to the same table) about 200 miles apart.
about 5% of the entries end up being stored without the "-" causing difficulties in generat1ng reports.
Any assistance in getting the table to store the data in the correct format would be appreciated.
---
Tom
