![]() Web addresses (using Lower(Web Address Field) or States using Upper (State Field)Īs to finding the telephone numbers easily you have two choices. This guarantees great data formatting.Īlongside this you can use it to format the resulting text of the field to anything you want, such as phone numbers (no matter HOW the user enters it) as well as other examples like ![]() Remember the old proverb, “Never put off to tomorrow what you can do today, because if you like it today you can do it again tomorrow!Įnjoy yourself, designing your own solution is a rush! No drugs needed.įirstly if you use the Auto enter calc value with the do not replace option unchecked you can automatically remove returns or any other characters from fields without the user worrying about it. You may also want to check the Display custom message and put in something like “A carriage return cannot be entered into this fieldâ€. ![]() Trust me, there is no benefit to your solution to have caarriage returns all over the system and its easy to stop! Just go to the Define fields, double click on PhoneNbr, click validation, click the arrow box in front of Validated by calculation and put the following in the box. Its a problem because, as you know Pc keyboards show “Enter†on both the Enter key and the Return Key. ![]() One other thing you may want to consider for the PhoneNumber field and other fields as well, for that matter. By entering numbers only, it’s fast, it’s simple, and everything works perfect in find mode! A significant problem when you consider how many ways a number can be entered. Why, because if the phone number is initially entered as 800/555-1212 that is exactly how it must be entered when you want to find it. The problem with all this coolness is finds become almost impossible. We can build you a calculation that no matter what you enter, once you tab out of the field it will be formatted just as you want it. As you see, many ways to do the same thing! But keep it simple, that always works best! Just be a little careful of the direction you choose.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |