Data Validation

[broknlgs24]

i'm pretty new when it comes to creating Outlook Forms and have a few
questions. i'm trying to create a form in outlook in which an end user
would fill out and email to someone else for data entry. the form has
6 columns and 8 rows. of the 6 columns, 4 are text boxes and 2 are
combo boxes. here's a layout of the columns (row 1 only) -

name action ID ID2 name2 serial#

name = text box. required.
[TechName1] <> ""

action = combo box. contains 4 values. must equal one of the 4 values.
[AMD1] = "Add" or [AMD1] = "Delete" or [AMD1] = "Modify" or [AMD1] =
"HHT"

ID = text box. must equal 7 characters.
Len( VZID1 ) = 7

ID2 = text box. must equal 3 characters.
Len( VZID1 ) = 3

name2 = combo box. contains 6 values. must equal one of the 6 values.
[AM1] = "xx" or [AM1] = "xx" or [AM1] = "xx" or [AM1] = "xx" or [AM1] =
"xx" or[AM1] = "xx"

serial# = text box. required
[OS1] <> ""

rows 2-8 are optional; however, if an end user decides to edit any of
the remaining rows, all remaining columns in that row must have the
same data validation as row 1.

does any of this make sense? could i use a checkbox to set row-by-row
visible if checked?

 

[Sue Mosher [MVP-Outlook]]

could i use a checkbox to set row-by-row visible if checked?

Yes, bind it to a custom Outlook property (so you can use it in your validation formulas) and use the CustomPropertyChange event to show the desired controls. See http://www.outlookcode.com/d/propsyntax.htm

You can cut down on two formulas by setting the combo boxes' MatchRequired property to True.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

i'm pretty new when it comes to creating Outlook Forms and have a few
questions. i'm trying to create a form in outlook in which an end user
would fill out and email to someone else for data entry. the form has
6 columns and 8 rows. of the 6 columns, 4 are text boxes and 2 are
combo boxes. here's a layout of the columns (row 1 only) -

name action ID ID2 name2 serial#

name = text box. required.
[TechName1] <> ""

action = combo box. contains 4 values. must equal one of the 4 values.
[AMD1] = "Add" or [AMD1] = "Delete" or [AMD1] = "Modify" or [AMD1] =
"HHT"

ID = text box. must equal 7 characters.
Len( VZID1 ) = 7

ID2 = text box. must equal 3 characters.
Len( VZID1 ) = 3

name2 = combo box. contains 6 values. must equal one of the 6 values.
[AM1] = "xx" or [AM1] = "xx" or [AM1] = "xx" or [AM1] = "xx" or [AM1] =
"xx" or[AM1] = "xx"

serial# = text box. required
[OS1] <> ""

rows 2-8 are optional; however, if an end user decides to edit any of
the remaining rows, all remaining columns in that row must have the
same data validation as row 1.