Problem with advanced search on custom field w/ formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
A better approach would probably be to search on the constituent fields, rather than on the formula field.
 
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


Sue Mosher said:
A better approach would probably be to search on the constituent fields, rather than on the formula field.
Click to expand...
 
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


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