A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Applying a changed form to existing contacts



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get existing contacts on a new form Ive created? jp Outlook and VBA 0 September 15th 06 04:43 PM
Default Contacts Form Has Suddenly Changed Graham Bond Outlook - Using Contacts 13 June 30th 06 12:12 AM
Move Contacts from an Existing Form Into a New Form Hal Outlook - Using Forms 2 March 6th 06 02:08 PM
outlook 2000 -- new custom form, same existing contacts CYBER23HYPER Outlook - Using Forms 3 January 18th 06 09:42 PM
outlook 2003sp3: applying the inbuilt junkmail filter on existing messages? [email protected] Outlook - General Queries 2 January 18th 06 06:47 PM


All times are GMT +1. The time now is 01:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.