View Single Post
  #6  
Old October 11th 06, 02:39 AM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Applying a changed form to existing contacts

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?


Ads