Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 09-17-2015, 06:26 PM
Perk Perk is offline Form Controls - Calculation Options Mac OS X Form Controls - Calculation Options Office for Mac 2011
Novice
Form Controls - Calculation Options
 
Join Date: Sep 2015
Posts: 13
Perk is on a distinguished road
Default

Hi Paul,



I am not sure if you will still receive this message since I selected Solved on the item, but I have a question for you on the form. I tried to replicate the fillform on a separate document but it would not appear. In fact the entire value would not appear. How do I create the formula from scratch? Do I start with the cross reference tool, and then modify from there? I actually tried that but to no avail.
Reply With Quote
  #17  
Old 09-17-2015, 08:23 PM
macropod's Avatar
macropod macropod is offline Form Controls - Calculation Options Windows 7 64bit Form Controls - Calculation Options Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

You could just copy/paste the formula field from one document (e.g. the one you already have) to the other...

Creating one from scratch entails pressing Ctrl-F9 to create a pair of field braces, filling them with whatever text you need, adding another pair of field braces (alongside or nested, according to the formula requirements), filling them with whatever text you need, and so on, till you've built up the entire formula. When doing it manually, you need to ensure there are spaces between the various expressions (otherwise IF tests, for example, won't work) and to get the structure & logic right. The tutorial you now have contains many examples.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #18  
Old 09-18-2015, 06:55 AM
Perk Perk is offline Form Controls - Calculation Options Mac OS X Form Controls - Calculation Options Office for Mac 2011
Novice
Form Controls - Calculation Options
 
Join Date: Sep 2015
Posts: 13
Perk is on a distinguished road
Default

Thank you. I will use the guide to identify and practice the formulas.
Reply With Quote
Reply

Tags
calculations, combo box, formulas



Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Controls - Calculation Options Updating an old form with Content Controls Something Anon Word 4 03-26-2014 03:53 PM
Form Controls - Calculation Options Form field calculation returning 2x correct result Jschueller Word 1 08-20-2013 01:51 PM
Adding controls to a form. supercrewed Outlook 0 02-14-2013 02:12 PM
Form controls in Excel 2011 for MAC AHB Excel Programming 0 12-28-2011 10:57 AM
Content Controls Form Programming beachdog Word VBA 4 09-20-2011 10:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:54 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