#16
|
|||
|
|||
I believe this might work.
Quote:
I believe this will work for me, but I'm having trouble picturing what you mean by, "To output the RPM +/- 10, simply use another formula field, coded as: {=RPM+10} or: {=RPM-10}[/quote]". Would you mind please elaborating or showing me an example? Thanks again! Your help is appreciated! |
#17
|
|||
|
|||
He did show you an example. The fields that start with = are formula or calculation fields.
|
#18
|
|||
|
|||
Error message!
Quote:
Do I need to add something like this, {=RPM+10\# "0000 rpm"}, without referencing anything? This, {=RPM+10}, gives me an error. |
#19
|
||||
|
||||
See attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#20
|
|||
|
|||
Thanks!
I really appreciate the help. One more thing.....
Is it possible to not have the 10's show up. It would be ideal to have that place blank when there isn't a product chosen. |
#21
|
||||
|
||||
You could change the:
{=RPM+10} and: {=RPM-10} field codes to: {=(RPM>0)*(RPM-10) \# 0} and: {=(RPM>0)*(RPM+10) \# 0} respectively. This will cause them to display 0s while ever the RPM field is empty. To suppress even the 0s, change the final 0 in each field to: "0;;"
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#22
|
|||
|
|||
You are the man!
Quote:
Again, Thanks a million!!!! |
#23
|
||||
|
||||
You won't find any books that go into field coding in much detail. I did contribute to one some years ago (Word Hacks, by A Savikas, published by O'Reilly Media in 2005 (Word Hacks - O'Reilly Media)) but even that doesn't cover anywhere near as much as the tutorials I've written on the subject. Indeed, my tutorials probably contain more detail than you'd find in all the books you could buy on the subject.
To start with, check out my Mailmerge Tips & Tricks: https://www.msofficeforums.com/mail-...ps-tricks.html To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial: https://www.msofficeforums.com/word/...-tutorial.html To see how to just about else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at: https://www.msofficeforums.com/word/...-tutorial.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#24
|
|||
|
|||
Cross-References
I'm having trouble with cross references. They used to show up in the middle of a sentence at the very most three dots.
Now I'm getting around 25 or so dots and it's causing huge formatting issues. Is there a way to change this? I have a line later on in the document referencing a drop down choice: Selected _Product_ID. ___________ It's pushing everything off the page and really looks horrible. I thought it might be a setting in options, but I couldn't find anything to do with cross references. Thanks in advance! |
#25
|
||||
|
||||
The only reason that would occur is because whatever you're cross-referencing has the same setup.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#26
|
|||
|
|||
Hi Macropod
The attached example is a great starting point for another idea you have given me. Instead of assigning a value to Code or Location, can it be set to be a text input field ? Thank you J |
#27
|
||||
|
||||
I'm not sure what you mean - the document already contains two dropdowns for data selection. Although a text formfield could be used for the input, that introduces the possibility of the input being invalid for any number of reasons and, hence, not being amenable for generation of the output.
I nay event, your other threads have all concerned the use of content controls, not formfields, and content controls & formfields should not be used in the same document. They weren't designed to be used that way and trying to do so is a known source of problems.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MACRO - Insert row based on Form Field Criteria | Elan05 | Word VBA | 5 | 04-16-2013 06:39 AM |
Nested if field that contains a fill-in field is not prompting for fill-in info | Nccadm | Mail Merge | 2 | 04-02-2013 03:15 AM |
Form file timesheet, auto fill date from calander | jkeeney | Word | 1 | 03-21-2012 12:21 AM |
Macro to populate a text form field based on dropdown selection | koloa | Word | 0 | 10-20-2011 11:52 AM |
How can I fill in form I received in email that used underlines instead of text field | Gail L. | Word | 2 | 05-17-2009 12:38 PM |