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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
problem protecting calculated field in table
I have a form document created in word 2003 that calculates 2 fields to be
input by a user of this form. I have form protection turned on, but I cannot figure out how to protect the calculated field so when this form is shared with the users, they cannot change it. I need to protect this field but still have it calculate! Is there a way to do this? |
#2
|
|||
|
|||
problem protecting calculated field in table
There's a setting for "Fill-in enabled." Clear that check box.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Kelly" wrote in message ... I have a form document created in word 2003 that calculates 2 fields to be input by a user of this form. I have form protection turned on, but I cannot figure out how to protect the calculated field so when this form is shared with the users, they cannot change it. I need to protect this field but still have it calculate! Is there a way to do this? |
#3
|
|||
|
|||
problem protecting calculated field in table
This box is already clear.
"Suzanne S. Barnhill" wrote: There's a setting for "Fill-in enabled." Clear that check box. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Kelly" wrote in message ... I have a form document created in word 2003 that calculates 2 fields to be input by a user of this form. I have form protection turned on, but I cannot figure out how to protect the calculated field so when this form is shared with the users, they cannot change it. I need to protect this field but still have it calculate! Is there a way to do this? |
#4
|
|||
|
|||
problem protecting calculated field in table
Use a Formula field that isn't a form field?
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Kelly" wrote in message ... This box is already clear. "Suzanne S. Barnhill" wrote: There's a setting for "Fill-in enabled." Clear that check box. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Kelly" wrote in message ... I have a form document created in word 2003 that calculates 2 fields to be input by a user of this form. I have form protection turned on, but I cannot figure out how to protect the calculated field so when this form is shared with the users, they cannot change it. I need to protect this field but still have it calculate! Is there a way to do this? |
#5
|
|||
|
|||
problem protecting calculated field in table
Hi Kelly,
Are the other fields set to 'calculate on exit', and does your calculating field refer to the bookmarks set by those other fields? Also, is the calculating field in the protected part of the document? Cheers "Kelly" wrote in message ... I have a form document created in word 2003 that calculates 2 fields to be input by a user of this form. I have form protection turned on, but I cannot figure out how to protect the calculated field so when this form is shared with the users, they cannot change it. I need to protect this field but still have it calculate! Is there a way to do this? |
#6
|
|||
|
|||
problem protecting calculated field in table
Tried switching it to a straight calculation and it still will not calculate
when the form is in the "locked" position. I have also tried the form field calculation with the calculate on exit. Does not work if the form is locked. I am not sure about the bookmark I need more information regarding this. FYI the entire form is locked. "macropod" wrote: Hi Kelly, Are the other fields set to 'calculate on exit', and does your calculating field refer to the bookmarks set by those other fields? Also, is the calculating field in the protected part of the document? Cheers "Kelly" wrote in message ... I have a form document created in word 2003 that calculates 2 fields to be input by a user of this form. I have form protection turned on, but I cannot figure out how to protect the calculated field so when this form is shared with the users, they cannot change it. I need to protect this field but still have it calculate! Is there a way to do this? |
#7
|
|||
|
|||
problem protecting calculated field in table
Why don't you share with us:
1. The bookmark names of the variable fields. 2. The formula field that you are using. Ensure that "Calculate on exit" is checked in the variable fields and "Fill-in enabled" in unchecked in the formula field. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table problem | Redwood | Database Design | 29 | April 3rd, 2006 04:58 PM |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |