![]() |
#16
|
|||
|
|||
![]()
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. |
#17
|
||||
|
||||
![]()
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] |
#18
|
|||
|
|||
![]()
Thank you. I will use the guide to identify and practice the formulas.
|
![]() |
Tags |
calculations, combo box, formulas |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Something Anon | Word | 4 | 03-26-2014 03:53 PM |
![]() |
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 |