Exchange & Outlook UPDATE, Outlook Edition, February 25, 2003

Sue Mosher explains how to control the data that users enter in custom Outlook forms and the printing of that data.

ITPro Today

February 24, 2003

9 Min Read
ITPro Today logo in a gray background | ITPro Today

********************

Exchange and Outlook UPDATE, Outlook Edition--brought to you by Exchange & Outlook Administrator, the print newsletter with practical advice, how-to articles, tips, and techniques to help you do your job today. http://www.exchangeadmin.com

********************

~~~~ THIS ISSUE SPONSORED BY ~~~~

How Real Time Monitoring Will Benefit YOU http://www.tntsoftware.com/winex021803

Intuitive Desktop Management...Profile Maker 8! http://www.AutoProf.com/Update_EO_Sec_2003_02_25.html below COMMENTARY

~~~~~~~~~~~~~~~~~~~~

~~~~ SPONSOR: HOW REAL TIME MONITORING WILL BENEFIT YOU ~~~~ A proactive Exchange Administrator installed TNT Software's ELM Enterprise Manager 3.0 on his critical servers to assess the benefits of real time monitoring. During the first week, EEM 3.0 paged him when his SMTP gateway went down, alerted him when the QoS of his Outlook Web Access site began to drop, and automatically restarted a failed POP3 service. As a result, ELM Enterprise Manager was purchased and fully deployed during the second week. Download your FREE 30 day full featured evaluation copy today and experience how real time monitoring will benefit YOU. http://www.tntsoftware.com/winex021803

~~~~~~~~~~~~~~~~~~~~

February 25, 2003--In this issue:

1. COMMENTARY - Controlling the Data That Users Enter in Custom Outlook Forms

2. ANNOUNCEMENTS - Join the HP & Microsoft Network Storage Solutions Road Show! - Try Windows & .NET Magazine!

3. HOT RELEASES - MaX Compression Enterprise: Desktop, Server, Gateway - FREE Directory Reporting Tool - WIN AN MP3 PLAYER

4. RESOURCE - Tip: Suppressing Default-Field Printing

5. NEW AND IMPROVED - Compress or Decompress OWA Attachments

6. CONTACT US See this section for a list of ways to contact us.

********************

1.

COMMENTARY

(contributed by Sue Mosher, News Editor, [email protected])

* CONTROLLING THE DATA THAT USERS ENTER IN CUSTOM OUTLOOK FORMS

One of the challenges that face designers of custom Outlook forms is how to make the data that users enter look exactly right. Native Outlook techniques don't cover all situations, but they address many common, simple data-entry needs. You'll need to have your form in design mode before implementing the techniques I describe here.

Frequently, form designers want to limit the number of characters that users can type into a particular text box on a form. To do so, right-click the text box, choose Advanced Properties, and enter the desired limit as the value for the MaxLength property. When users try to type more characters than the limit, they won't receive an error message--they just won't be able to type further.

If you've used Microsoft Access forms, you might be familiar with Access's Input Mask Wizard, which lets you limit the number of characters that users can type and force them to type characters in a particular formatted sequence. Unfortunately, Outlook doesn't include any capability for using an input mask to handle telephone or Social Security numbers or other tightly formatted data. Both Microsoft and third-party software vendors provide input-mask controls that you can use on an Outlook form. However, if you use one of these, you must provide a setup program that properly registers the control on each user's machine.

Outlook will try to properly reformat a telephone number in one of its built-in phone fields automatically. However, this functionality disappears in Outlook 2000 if you customize the first page of the contact form. The Microsoft article "OL2000: How to Use the Intellisense Feature in Outlook to Format Custom Phone Number Fields" ( http://support.microsoft.com/?kbid=266267 ) suggests a workaround using some VBScript code behind the form.

Another simple technique built into Outlook is to mark a certain property as required. To access this and more-complex validation options, right-click the control that displays the property, then choose Properties and go to the Validation tab. The simplest validation choice--the "A value is required for this field" check box--might look easy to use, but it's actually a bad choice. If you use it and the user doesn't enter data in the required field, the user receives only a cryptic "A field on this form requires a value" prompt that gives no hint as to which field needs data.

If you want to require entry in a text field, a better solution is to enter this simple formula in the Validation Formula box:

[TextFieldName] ""

where TextFieldName is the actual name of the built-in or custom text property that you want to validate. You can click Edit next to the Validation Formula box and choose the field from the Fields list. Using a validation formula lets you create a custom error message in the "Display this message if the validation fails" box, telling the user which field needs a value and any specific requirements for that value.

Both the simple validation of a required property and formula-based validation can work even with built-in properties that appear on a page that you can't customize, such as the Details page on a contact form. The trick is that the validation information is actually stored with the property, not as part of the form layout. Knowing that, you can create a new custom page on your form, drag a built-in property from the Field Chooser, then use the Validation tab of the control for that property to set up the validation. Before you publish the form, you can hide that page with the Form, Display This Page toggle command.

Validation has one big potential pitfall: Because Outlooks stores the validation information with the property, the validation setting always applies regardless of whether the user can actually enter data for that field on the form. In particular, it applies even if you remove the control from the form. What's worse, as I mentioned above, if you use the simple required field validation technique, the error message doesn't actually tell you which property's data is missing. Therefore, before removing a control from an Outlook form, you should always check the Value tab on the control's Properties dialog box and clear any validation options.

If you want to build a more complex validation formula, perhaps involving multiple fields, my Commentary "More About Outlook Formulas," http://www.winnetmag.com , InstantDoc ID 21002, should be helpful. I'd love to hear about any validation challenges that you've faced and the solutions you devised.

~~~~~~~~~~~~~~~~~~~~

~~~~ SPONSOR: INTUITIVE DESKTOP MANAGEMENT...PROFILE MAKER 8! ~~~~ What you always wanted in Desktop Management - Visually map network drives, shared and TCP/IP printers, copy files, create folders and shortcuts. Install service packs and MSI packages. Set application settings, manage Outlook Profiles, and deploy system policy & scripts. Control execution based on OS, IP Address Range, Date, Time, Recurrence, "Run Once," Environment Variable, Type of Dial-Up Connection, OU, Site, Language/Locale, MAC Address, DNS Name, various hardware criteria, and Terminal Server/MetaFrame options. For more info: http://www.AutoProf.com/Update_EO_Sec_2003_02_25.html

~~~~~~~~~~~~~~~~~~~~

2.

ANNOUNCEMENTS

(brought to you by Windows & .NET Magazine and its partners)

* JOIN THE HP & MICROSOFT NETWORK STORAGE SOLUTIONS ROAD SHOW! Now is the time to start thinking of storage as a strategic weapon in your IT arsenal. Come to our 10-city Network Storage Solutions Road Show, and learn how existing and future storage solutions can save your company money--and make your job easier! There is no fee for this event, but space is limited. Register today! http://www.winnetmag.com/roadshows/nas

* TRY WINDOWS & .NET MAGAZINE! Every issue of Windows & .NET Magazine includes intelligent, impartial, and independent coverage of security, Active Directory, Microsoft Exchange Server, and more. Our expert authors deliver how-to content you simply can't find anywhere else. Try a sample issue today, and find out what more than 100,000 readers know that you don't! http://www.winnetmag.com/rd.cfm?code=fsei203xup

3.

HOT RELEASES

* MAX COMPRESSION ENTERPRISE: DESKTOP, SERVER, GATEWAY Reduce the growth of your 50GB Exchange Server by 49GB*! Cut bandwidth needs by up to 55%. Over 2.5m Outlook & Exchange users choose the de-facto standard for invisible e-mail compression - Download today! http://www.c2c.com/r/eosave.htm

* FREE DIRECTORY REPORTING TOOL - WIN AN MP3 PLAYER Create accurate reports on objects within your GAL with a single click! SmartR from Imanami builds customizable reports in CSV, XML, XLS and HTML. Download FREE - win an MP3 Player. http://www.imanami.com/specials/winnet/030226.asp?p=winnet_030226

4.

RESOURCE

(contributed by Sue Mosher, [email protected])

* TIP: SUPPRESSING DEFAULT-FIELD PRINTING

Q: How can I avoid printing the Total Work and Actual Work fields in a custom task form?

A: Outlook prints certain fields on each form by default. However, when you're using a custom form, you can turn this default printing on or off for each field through the properties of the control that displays the field.

Because the Total Work and Actual Work fields appear on a task form's Details tab, you first need to add them to a custom page by dragging them from the Field Chooser. Then, for each of the fields, right-click the text-box control, choose Properties, go to the Validation tab, and clear the "Include this field for Printing and Save As" text box. Finally, choose the Form, Display This Page toggle option to hide this custom page because it duplicates fields already present on the Details page.

See the Exchange & Outlook Administrator Web site for more great tips from Sue Mosher. http://www.exchangeadmin.com

5.

NEW AND IMPROVED

(contributed by Carolyn Mader, [email protected])

* COMPRESS OR DECOMPRESS OWA ATTACHMENTS Mail4ce announced a Mail4ce Outlook Web Access (OWA) Client for the Mail4ce Compression Suite that provides compression and decompression of all OWA email attachments. Another component of the suite, Mail4ce Compression Gateway, compresses all inbound email before it reaches the mail server. The Mail4ce Compression Client provides transparent compression and decompression of email attachments for LAN users. The Mail4ce OWA Client is bundled with the Mail4ce Compression Suite, which costs $1795 for the gateway and $6.50 per seat based on a volume of 2500 users. Contact Mail4ce at 877-470-0008. http://www.mail4ce.com

6.

CONTACT US

Here's how to reach us with your comments and questions:

* ABOUT THE COMMENTARY -- [email protected]

* ABOUT THE NEWSLETTER IN GENERAL -- [email protected] (please mention the newsletter name in the subject line)

* TECHNICAL QUESTIONS -- http://www.winnetmag.com/forums

* PRODUCT NEWS -- [email protected]

* QUESTIONS ABOUT YOUR EXCHANGE AND OUTLOOK UPDATE SUBSCRIPTION? Customer Support -- [email protected]

* WANT TO SPONSOR EXCHANGE AND OUTLOOK UPDATE? [email protected]

********************

Receive the latest information about the Windows and .NET topics of your choice. Subscribe to our other FREE email newsletters. http://www.winnetmag.com/email

|-+-|-+-|-+-|-+-|-+-|

Thank you for reading Exchange and Outlook UPDATE. __________________________________________________________ Copyright 2003, Penton Media, Inc.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like