Problem with input mask and combo box

B

Boon

I have a table with several coulmns including column Phone Number. The
column Phone Number, I put the input mask as ###\-####;0;

If I understand correctly, this mask means that I want to store the "-" in
the field as well, not just the number.

The problem is, when I use a combo box in the form to filter by the phone
number, and display other fields information in the subform table. The list
in the combo box doesn't contains the "-". The combo work fine, but when I
manually type in the phone number with "-", Access couldn't find the
records.

Thanks a lot
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top