I am having problems finding contacts in my public outlook folder. Here is the code:

*********
oOutLookObject = CreateObject("Outlook.Application")
olNameSpace = oOutLookObject.GetNameSpace("MAPI")

oContacts = ;
olNameSpace.Folders("Public Folders").;
Folders("All Public Folders").;
Folders("MIS Contacts").Items

oContactItem = oContacts.Find("[CompanyName] = " + "'" + ThisForm.txtCompany.Value + "'")


*********
No matter what I have in txtCompany, oContactItem is NULL, even when the company DOES exist in the public MIS CONTACTS folder. I have also tried padr(ThisForm.txtCompany,255,' ') since MSDN says companyname is 255.

Any advice would be appreciated. BTW, anyone know how sensitive the FIND is (ie case or length).

TIA,

Rob