Validation

[Brad]

Hi

I am trying to set up a Validation rule that if on field has information
another field needs to not equal None.

I have tried ([Field1] = "") OR ([Field2] <> "None")

Field1 is a combo box andn Field2 is a text box.

Thanks in advance!

 

[Sue Mosher [MVP-Outlook]]

You cannot use the names of controls -- combo box or text box -- in a formula. You must use the names of Outlook fields. If Field1 and Field2 are indeed fields, not controls as you described, what type of fields are they -- text, date/time, numeric, yes/no?

 

[Brad]

Thanks for the fast reply Sue.

They are fields, one is text and the other is Time/Date with format dd mmm,
yyyy.

You cannot use the names of controls -- combo box or text box -- in a formula. You must use the names of Outlook fields. If Field1 and Field2 are indeed fields, not controls as you described, what type of fields are they -- text, date/time, numeric, yes/no?
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

Hi

I am trying to set up a Validation rule that if on field has information
another field needs to not equal None.

I have tried ([Field1] = "") OR ([Field2] <> "None")

Field1 is a combo box andn Field2 is a text box.

Thanks in advance!

 

[Sue Mosher [MVP-Outlook]]

In that case, the formula you originally posted should work fine. It certainly worked for me here. Just make sure you use the custom property names, not the control names, in the formula. If you use the Edit button to bring up the validation formula editor, you'll see the available fields to pick from.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

They are fields, one is text and the other is Time/Date with format dd mmm,
yyyy.

You cannot use the names of controls -- combo box or text box -- in a formula. You must use the names of Outlook fields. If Field1 and Field2 are indeed fields, not controls as you described, what type of fields are they -- text, date/time, numeric, yes/no?

I am trying to set up a Validation rule that if on field has information
another field needs to not equal None.

I have tried ([Field1] = "") OR ([Field2] <> "None")

Field1 is a combo box andn Field2 is a text box.