Sounds like you are having a problem with your input mask and how the data is stored in the table. When you look at the data in the table, do you see the dash in the data? If not, then Access is not storing the dash. When you set up the table, did you create an input mask, and if so, did you tell Access to store the data with the mask or without?