[MS_AccessPros] Phone number formating

 

I am putting together a form that will look up clients based on a few items. One of the items is Home Phone number. I created a combo box that searches the table t_Clients.

In the table I have the input mask as phone number.

the problem is that I am getting phone numbers showing up in the combo box with the dashes in different places. I am getting these formats...

123-456-7890
123456-7890
123-4567890

Any idea what I have to do to get all the phone numbers in the combo box to show up the same way. The search function of the combo box uses the dash as part of its sorting and could cause the end user to miss the number if the dash is put, or not put in.

Thanks,
Bill

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___