Recent content by Eljefegeneo

I know I am kicking this thing to death, but the other day my wife told me that she and our daughter-in-law were talking about something person to person in the same room, although her phone was on. Then she went on Facebook (yes the evil one)later on and lo and behold an ad came up for what...

Go play golf, come home grumping about their "game" and then talk about how they just can't wait to go golfing again. :p

You ever hear of the saying.... "If it ain't broke, don't fix it"!!

For what it is worth, I had a lot of trouble with this too and finally found this that works for me. It is a module that tests for Outlook being open. If not then Outlook is opened. Sub TestOutlookIsOpen() Dim A, B, C, D As String A = "Outlook Is Not Open, Outlook Will Now Open." B =...

I do not know if this will be of any help, but I used this for inputting telephone numbers (10 digit numbers) so that regardless of what the user entered, the correct format would be shown. I put in an unbound text box where the user could enter the ten digits in any format that I could think...

Do your cars fly? More advanced then anything here in California. Ours don't have wings! 🤪

I ave used this for years and it works great. No spaces if anything is missing. You can adapt it to your particular application. With the proper carriage return codes, of course. =([Title]) & (" "+[FirstName]) & (" "+[MiddleName]) & (" "+[Surname]) & (" "+[NameSuffix])

So, finally I came up with what I think is a decent solution. I set up the unbound text box to be visible if there is no telephone number listed. Then I paste the telephone number in any format into it and use Double Click event to populate the telephone control. First I used an extended...

My way seems to work except, always the except, if you paste 8005551212 and double click it enters 805551212 and not the input mask format. Likewise for 800.555.1212, gets pasted as 800.555.1212. Most other formats work fine. Going to have to figure out how to get these odd formats into the...

Yes, I now understand. I fixed it in my usual half ass way. Put in an unbound text box (like a note pad) only visible if nothing in the Telephone control, paste the number to the unbound text box and then on double click it enters into the Telephone control and the unbound text box disappears.

Pasting into the notepad works fine. It just doesn't go into the text field. It will if I paste it to an unbound text box and then use code to update the Telephone text box.

No validation rule, just the input mask.

I am trying to copy a telephone number from a web page and paste it into my form. The text field on the form is the standard ten digit USA telephone input mask. !\(999") "000\-0000;0;_ But when I try to copy a telephone number, 212-555-1212 or (212)-555-1212 or 212.555.1212 only the first three...

GotFocus did not work properly. Only the Onclick.

Thank you. I hadn't tried the on click event. Of course it works fine. Just wondering why it wouldn't work on the OnFocus on OnMouseDown.