On Aug 1, 11:34*am, "Eric Legault [MVP - Outlook]"
wrote:
The problem is that the formula in that field is returning an error because
the values in the fields that make up the formula calculation return an
invalid result. *You can include better logic in the formula to test for
invalid results and return a blank/null value; the IIF function is a good
candidate.

--
Eric Legault [MVP - Outlook]
MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007
& WSS 3.0 Application Development)
President
Collaborative Innovations
- Try Picture Attachments Wizard 2.0 For Microsoft Outlook -
- Take your SharePoint content offline * * * * * * * * * * -
- More info:http://www.collaborativeinnovations.ca* * * *-
Blog:http://blogs.officezealot.com/legault

"srm" wrote in message

...

On Jul 30, 10:52 am, srm wrote:
I'm using O2003. I added Combination field and for each new contact
it works fine. The trouble I'm having is until I open a current
contact and edit it, the value of #ERROR appears in the field. I've
tried to complete a group update so the data changes (city, title,
etc.), but no luck. I have around 10,000 names so editing each one
manually is not something to look forward to.

Any ideas to complete the group update so the contact gets updated and
the #ERROR is removed? I also tried to apply an old form and then
reapply my custom form. No luck.

[Full Name]
[Job Title]
[Company]
[Business Address]

Dear [First Name]:

Thanks.

Shawn

After trying some items, now I always get the #ERROR. *I edit the data
for a contact, see it being updated in the field (while I'm still in
the contact), save the contact, and when I open the contact again, the
field reflects #ERROR again.

Hopefully its something simple that I'm missing.

Shawn

Eric:

Thank you. I will give that a try. I appreciate your help.