Re: How to customize a text field based on a choice from a combo box

Tech-Archive recommends: Fix windows errors by optimizing your registry

Validation works like this: The validation formula must return True when the data is "good" and False when it is "bad." In your scenario, you have two cases where the data is "good":

When Choice #1 has been chosen in the combo box and the user has typed a number in the text box
When Choice #2 has been chosen in the combo box

As far as the formula goes, you can ignore Choice #1 itself, and use something like:

([ComboBoxField] = "Choice 2") OR ([TextBoxField] <> "default")

See how the two "good" types of data translate into two expressions, joined by OR?
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"L.C" <LC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:20A2811B-19D1-4C2A-A6BE-58EB16628449@xxxxxxxxxxxxxxxx
> Hi there,
>
> I would like to link a text field to a combo box such that when a specific
> choice is made in the Combo Box, the User HAS to type in a number in the text
> box. There are only 2 choices in the Combo Box and the validation is set such
> that the User HAS to make one of the two choices. Now I want to do a second
> 'validation'- when the user makes ONE of the two choices, the user HAS to
> change the default text in the text box. I tried using an IIF statement in
> the text control (Properties, Validation): IIF([combo1]="choice1",
> [text1]<>"default", ""), but it doesn't work with either choice. Any
> suggestions? oh, and I'm SO NOT a developer or coder or whatever they're
> called.
>
> Thanks,
> L.C.
>
>
.

Relevant Pages

  • Re: Setting or adding data to a form field
    ... Author of Configuring Microsoft Outlook 2003 ... Administrators, Power Users, and Developers ...
    (microsoft.public.outlook.program_forms)
  • Re: Setting or adding data to a form field
    ... Author of Configuring Microsoft Outlook 2003 ... Administrators, Power Users, and Developers ...
    (microsoft.public.outlook.program_forms)
  • Re: Outlook Task Priority
    ... Author of Microsoft Outlook 2007 Programming: ... Jumpstart for Power Users and Administrators ... out how to add the Custom Priority field to my Task/To-Do List, ...
    (microsoft.public.outlook.program_forms)
  • Re: Outlook Rule now working
    ... Author of Configuring Microsoft Outlook 2003 ... Administrators, Power Users, and Developers ...
    (microsoft.public.exchange.clients)
  • Re: Organizational Forms Library Permissions?
    ... Author of Configuring Microsoft Outlook 2003 ... Administrators, Power Users, and Developers ...
    (microsoft.public.outlook.program_forms)