Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-04-2023, 10:45 AM
Krhamm Krhamm is offline Legacy Text Field with Calculation is Rounding Windows 11 Legacy Text Field with Calculation is Rounding Office 2021
Novice
Legacy Text Field with Calculation is Rounding
 
Join Date: Dec 2023
Posts: 11
Krhamm is on a distinguished road
Default Legacy Text Field with Calculation is Rounding


I'm using a legacy text field within a table to input a calculation that displays as 0.00%. The calculation works but it rounds. so if the answer should be 3.50% it rounds it to 4.00%. Is there a way to stop this from happening?
Reply With Quote
  #2  
Old 12-04-2023, 03:28 PM
Guessed's Avatar
Guessed Guessed is offline Legacy Text Field with Calculation is Rounding Windows 10 Legacy Text Field with Calculation is Rounding Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

What does the field code show when you toggle the field codes?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 12-05-2023, 10:26 AM
Krhamm Krhamm is offline Legacy Text Field with Calculation is Rounding Windows 11 Legacy Text Field with Calculation is Rounding Office 2021
Novice
Legacy Text Field with Calculation is Rounding
 
Join Date: Dec 2023
Posts: 11
Krhamm is on a distinguished road
Default

{FORMTEXT {=(vert1-2)/2}}

vert 1 refers to another text box's input.
Reply With Quote
  #4  
Old 12-05-2023, 02:34 PM
Guessed's Avatar
Guessed Guessed is offline Legacy Text Field with Calculation is Rounding Windows 10 Legacy Text Field with Calculation is Rounding Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If you double click on the field, is there a Number Format set for it?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 12-13-2023, 02:39 PM
Krhamm Krhamm is offline Legacy Text Field with Calculation is Rounding Windows 11 Legacy Text Field with Calculation is Rounding Office 2021
Novice
Legacy Text Field with Calculation is Rounding
 
Join Date: Dec 2023
Posts: 11
Krhamm is on a distinguished road
Default

There is.

0.00

And it spits out the calculation in that format, but the digits to the right of the decimal always show as zeros instead of the actual calculation.
Reply With Quote
  #6  
Old 12-13-2023, 07:15 PM
Guessed's Avatar
Guessed Guessed is offline Legacy Text Field with Calculation is Rounding Windows 10 Legacy Text Field with Calculation is Rounding Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I can't reproduce the issue on my machine - mine calculates correctly.

Perhaps attach your document to a post here so I can see what you actually have in your document.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 12-14-2023, 10:36 AM
Krhamm Krhamm is offline Legacy Text Field with Calculation is Rounding Windows 11 Legacy Text Field with Calculation is Rounding Office 2021
Novice
Legacy Text Field with Calculation is Rounding
 
Join Date: Dec 2023
Posts: 11
Krhamm is on a distinguished road
Default

Here you go!
Attached Files
File Type: docx Table with Formula.docx (13.9 KB, 2 views)
Reply With Quote
  #8  
Old 12-14-2023, 06:38 PM
Guessed's Avatar
Guessed Guessed is offline Legacy Text Field with Calculation is Rounding Windows 10 Legacy Text Field with Calculation is Rounding Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't know what is going on with your form calculation field so just delete it and then replace it with a different field type.
Add a regular field in the last column by pressing Ctrl-F9. Then inside the {} which appear paste this text so it looks like { =(B2-2)/2 \# "0.000%" }
Then lock the form and try again.

In this formula, we are telling Word to use the value of Cell B2. So the Vertical acceptance formula will be almost the same but point at B3 instead.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #9  
Old 12-19-2023, 12:47 PM
Krhamm Krhamm is offline Legacy Text Field with Calculation is Rounding Windows 11 Legacy Text Field with Calculation is Rounding Office 2021
Novice
Legacy Text Field with Calculation is Rounding
 
Join Date: Dec 2023
Posts: 11
Krhamm is on a distinguished road
Default

Thanks. I removed the legacy text field and just used your field code in the table cell. That seemed to do the trick!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Unsure why running a macro that generates text is deleting the legacy form field I want the text in Rakyn87 Word VBA 1 03-18-2019 02:12 PM
Legacy Text Field with Calculation is Rounding Rounding a merge calculation to whole number finners01 Mail Merge 1 12-03-2018 04:55 AM
Legacy Text Field with Calculation is Rounding Currency Field not showing $ and is rounding Juliesctt Mail Merge 3 07-05-2016 06:43 PM
Legacy Text Field with Calculation is Rounding VBA Code to Insert Legacy Text Field PSSMargaret Word VBA 17 06-15-2016 04:22 AM
Legacy Text Field with Calculation is Rounding Grammar check into legacy forms > Text form field. Eduardo Care Word 2 09-09-2015 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:27 PM.


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