Display Phone Number - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Display Phone Number

David Clement

15 months ago

Richard,
This may be a silly question, but, here goes.
I have built a Contact Database that has a field for phone number.
It is setup as a text field, i.e.,8005551212, I have named it LookUpPhoneNumber in my table, to make it easy for a search, or so I think. I also have a field named PhoneNumber, also set up as a text field, this one is set up like this, (800)555-1212.
My form show these same fields, and the search runs and works okay as is.
Here is my question,
Can I have my search return the phone number with out having to show the LookUpPhoneNumber field on my form? Would I just have to make a different form with out that field?

Thank you.

	David Clement OP @Reply 15 months ago

	David Clement OP @Reply 15 months ago
Richard, I think I've got it. Still would like to know if there is a better way. Thank you.

	David Clement OP @Reply 15 months ago

	David Clement OP @Reply 15 months ago
My View Only Contacts Is a Locked Form. I only want to VIEW the Record Here.

	John Davy @Reply 15 months ago
Hi David, Have you thought about using a continuous form for the phone number(s) using the Customer number as the link? You could show all the customer's phone numbers, fax numbers etc. I don't see the value in your look up phone. John

David Clement OP @Reply

15 months ago

I didn't want to put an actual value in the phone number field.
In my Table, I have a Field Named: LookUpPhoneNumber: entered like this: 8005551212, to make it searchable.
I have a Field Named PhoneNumber with an input mask entered like this: (800)555-1212 so it will look like a phone number.
In my Add/Edit Form, I brought in ALL of my fields. doing that it showed my LookUpPhoneNumber on the form. I forgot that didn't really need to do that.
I think it works, but I'm sure there id a better way to do this.
Thank you for your input.

Marc Lievens @Reply

15 months ago

Hi David,

I added a search field to my table and put everything I want to look for in there. First, I strip all special characters ( ) - . , ... before adding the data and concatenate all the fields. Then, before searching, I strip the search data the same way and look for records that contain the stripped search value in the search field.

This works very well. If the user types in (0800)-123456 or 800123456, they get the same result.

Marc

	Marc Lievens @Reply 15 months ago
In the After Update event of the fields included in the search field, you also need to update the search field.

	Kevin Robertson @Reply 15 months ago
David Clement I don't understand why you have two fields for Phone Number and for Date of Birth. How are you performing the search?

	David Clement OP @Reply 15 months ago
I thought that is how you are supposed to do this. My Search Queries are wriiten like this: Like "" & [Forms]![SearchF]![LookUpDateOfBirth] & "" Like "" & [Forms]![SearchF]![PhoneNumber] & "" They both seem to works okay, but as I am definitely not an expert yet, I am quite sure there is a better way to do this.

	David Clement OP @Reply 15 months ago

	David Clement OP @Reply 15 months ago

	David Clement OP @Reply 15 months ago

	David Clement OP @Reply 15 months ago

	David Clement OP @Reply 15 months ago

	David Clement OP @Reply 15 months ago

	David Clement OP @Reply 15 months ago
Please let me know if there is a better way of doing this. Thank you so much.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View