Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 4,176
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
 

Thread Tools
Display Modes


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 05:27 AM.


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