Make phone numbers clickable

[njellis]

Good Day all!

I have an access database we've been using for a few years now. I have a form that pulls data directly from the client info table. One of the pieces of info is the client's phone number.

I would like it if I can make the phone numbers clickable with the "tel:" hyperlink tag.

Is there a way I can add info to the front of the control source, to make it a clickable url, without modifying the source table filled with information itself?

I.E. currently control source =[phone1]
I tried ="tel:"&[phone1]
Also tried (for testing} ="\<a href\=\"www\.google\.com\"\>"&[phone1]&"\<\/a\>" -- obviously just to see if it would turn into a url to go to google and that didn't work.

Thank you for any suggestions.
(P.S. this form does not pull through a query if that wasn't already obvious).

 

[Telecomgirl08]

Hi! It looks like you were close with the url test, I found this example that was recommended for people with similar problems to yours, hopefully this code works for you!

http://ux.stackexchange.com/questio...erlink-phone-numbers-using-tel-on-my-websites

"So, for example, you can create a link to 800-867-5309 with the following:"

<a href="tel:+18008675309">800-867-5309</a>

Amanda Long
Web specialist

http://www.atlasphones.com/

http://www.phonesysteminfo.com/