Validation

  • Thread starter Thread starter Brad
  • Start date Start date
B

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!
 
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?
 
Thanks for the fast reply Sue.

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



Sue Mosher said:
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


Brad said:
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!
Click to expand...
Click to expand...
 
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


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

Sue Mosher said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top