Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
How do I show results of a calculated field on a protected form?
On my form I have a numeric fill-in field for quantity ordered. How do I
show the results of multiplying this quantity by a fixed price? |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
How do I show results of a calculated field on a protected form?
Have another formfield on the document to contain the total set it to the
Calculation type and enter the necessary formula into the properties dialog. Set the Calculate on Exit property for the Quantity formfield. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Roy Lehmann" wrote in message ... On my form I have a numeric fill-in field for quantity ordered. How do I show the results of multiplying this quantity by a fixed price? |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
How do I show results of a calculated field on a protected form?
Hi Roy,
If you've got your formfield's properties set to 'calculate on exit', you can use a formula field, coded along the lines of: {=Text1*123.45 \# $,#0.00} where 'Text1' is the name of the bookmark set by your formfield and '123.45' is the price. If you've got another formfield to solicit the price, the coding might look like: {=Text1*Text2 \# $,#0.00} The '\# $,#0.00' at the end is a 'numeric picture switch', which formats the output - dollars and cents in this case, with a thousands separator. This approach gives less opportunity for problems than using another formfield to do the calculation. FWIW, you can create the field braces (i.e. '{ }') by pressing Ctrl-F9, or you could use Insert|Field= (Formula) - you can't simply type them. Cheers -- macropod [MVP - Microsoft Word] "Roy Lehmann" wrote in message ... | On my form I have a numeric fill-in field for quantity ordered. How do I | show the results of multiplying this quantity by a fixed price? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert image into a protected form field document? | Microsoft Word Help | |||
Text Form Field Too Small | Microsoft Word Help | |||
How to use spellcheck on a protected text form field? | Microsoft Word Help | |||
Drop-Down Form Field and IF Field | Microsoft Word Help | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help |