Since you have a Dutch version, did you pick the fields from the Field List to make sure you got the right names? (They may be localized for formula purposes.)
An ERROR# on first displaying the item could mean that one of the fields in the formula has never held any value.
The alternative to using a formula is to use a published form with code behind it to set the value of a text field. See
http://www.outlookcode.com/d/propsyntax.htm for syntax basics.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
"BartH_NL" wrote in message ...
I have a textfield with a formula like this in it:
[Company] & Chr(13) & Chr(10) & [Full Name] & Chr(13) & Chr(10) &
[Business Address]
The property of the field is set to "Auto calculate field" (or whatever this
is in English - I have a Dutch version) but it only recalculates after a
change to any field.
As I open an existing contact (with the new form) and I activate the tab
with the customized textbox (see post: Combining fields and new line), it
shows #ERROR and I have to change something in the form (anything), to get it
to recalculate and display the correct contents. After I save the form, the
correct contents remain.
Can I alter the field or form to avoid this?