Problem with advanced search on custom field w/ formula

[Bodo]

Hi,

I have a custom field named "searchcriteria" of type formula where initial
value is set to:
MyField1&" "&MyField2&" "&MyField3 and option "calculate formula
automatically" is set.

When I run the form, field "searchcriteria" displays the values as expected.

However when I attempt to use Outlook advance search and select
custom field "searchcriteria" as criteria, Outlook gives me all items as
result even if they don't match the criteria entered.

Anyone has any ideas how to troubleshoot?

 

[Sue Mosher [MVP-Outlook]]

A better approach would probably be to search on the constituent fields, rather than on the formula field.

 

[Bodo]

Hi Sue,
thanks for your post.

Now I use the forms Item_CustomPropertyChange event to set the value of my
userdefined field (Type Text) by concatenate the 3 customs fields.
Advanced search on that udf works fine.

--
Thanks in advance.
Bodo

A better approach would probably be to search on the constituent fields, rather than on the formula field.

 

[Sue Mosher [MVP-Outlook]]

Yes, that's another good solution.

--
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 Sue,
thanks for your post.

Now I use the forms Item_CustomPropertyChange event to set the value of my
userdefined field (Type Text) by concatenate the 3 customs fields.
Advanced search on that udf works fine.