Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2023, 11:33 AM
wwilkerson wwilkerson is offline forms calculation not entering/calculate upon exit Windows 10 forms calculation not entering/calculate upon exit Office 2010
Novice
forms calculation not entering/calculate upon exit
 
Join Date: Jan 2023
Posts: 4
wwilkerson is on a distinguished road
Default forms calculation not entering/calculate upon exit

Hi - I have created a form in word that has a section that is set up as a calculation table. All of it works except for the last field, it will not calculate upon exit (the box is checked). For example I put in 10 and hit Tab - the curser goes to the next field (a text field) to be filled out but the 10 stays as typed - doesn't convert into currency and doesn't get added into the total at the bottom. I hope that makes sense. I have gone over the set up multiple times and I can't see what's wrong. The only way to get the last box to add in is to click on one of the other calculation boxes. This is a scholarship application so lots of fill in fields that all need to work without weird glitches .

Attached is an unprotected version. Its the 3rd box in Loans page 2.

Please help! Thanks!!
Attached Files
File Type: docx WFL Colonial Scholarship Application 2023 - Copy.docx (35.7 KB, 6 views)
Reply With Quote
  #2  
Old 01-20-2023, 02:31 PM
macropod's Avatar
macropod macropod is offline forms calculation not entering/calculate upon exit Windows 10 forms calculation not entering/calculate upon exit Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your document contains a mix of content controls and formfields. Content controls and formfields were not designed to be used in the same document and trying to do so is a known source of problems. Delete the content controls and the formfields will calculate correctly.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-20-2023, 02:36 PM
Charles Kenyon Charles Kenyon is offline forms calculation not entering/calculate upon exit Windows 11 forms calculation not entering/calculate upon exit Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,584
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I've looked at your form and have no explanation. I also tried deleting the problem field and copying the one from above it giving it the old bookmark name. Same thing happened with that.
Reply With Quote
  #4  
Old 01-20-2023, 02:48 PM
wwilkerson wwilkerson is offline forms calculation not entering/calculate upon exit Windows 10 forms calculation not entering/calculate upon exit Office 2010
Novice
forms calculation not entering/calculate upon exit
 
Join Date: Jan 2023
Posts: 4
wwilkerson is on a distinguished road
Default

Macropod - I would like to keep the underlining I have set in the content control in a few boxes.. Is there anyway to keep that or is getting rid of it all the only way to make it work? And is there a way to see what I have done in for content control without opening each one? Sorry - this is my 1st attempt at doing this so 100% self taught.
Reply With Quote
  #5  
Old 01-20-2023, 04:00 PM
macropod's Avatar
macropod macropod is offline forms calculation not entering/calculate upon exit Windows 10 forms calculation not entering/calculate upon exit Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by wwilkerson View Post
Macropod - I would like to keep the underlining I have set in the content control in a few boxes.. Is there anyway to keep that or is getting rid of it all the only way to make it work? And is there a way to see what I have done in for content control without opening each one? Sorry - this is my 1st attempt at doing this so 100% self taught.
You will need to replace all your content controls with formfields. Underlining can be applied to formfields.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 01-21-2023, 08:22 AM
wwilkerson wwilkerson is offline forms calculation not entering/calculate upon exit Windows 10 forms calculation not entering/calculate upon exit Office 2010
Novice
forms calculation not entering/calculate upon exit
 
Join Date: Jan 2023
Posts: 4
wwilkerson is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You will need to replace all your content controls with formfields. Underlining can be applied to formfields.
Thank you! I think its working. Having someone test it now.
Reply With Quote
  #7  
Old 01-20-2023, 02:49 PM
wwilkerson wwilkerson is offline forms calculation not entering/calculate upon exit Windows 10 forms calculation not entering/calculate upon exit Office 2010
Novice
forms calculation not entering/calculate upon exit
 
Join Date: Jan 2023
Posts: 4
wwilkerson is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
I've looked at your form and have no explanation. I also tried deleting the problem field and copying the one from above it giving it the old bookmark name. Same thing happened with that.

I did the same thing hoping it would somehow resolve it
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
forms calculation not entering/calculate upon exit exit subscriptions sussertown Office 1 11-11-2019 05:25 PM
forms calculation not entering/calculate upon exit Error with exit macro brent chadwick Word VBA 5 01-28-2017 01:49 PM
Pictures animated exit abc3132 PowerPoint 0 02-26-2015 12:27 AM
Convert PPT to PDF, now need button to exit PDF RoyLittle0 PowerPoint 1 10-16-2013 04:07 AM
Is there an exit on close ? mhdadmh Word 0 10-12-2006 04:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft