Formulas

S

SeanM

Within a repeating table, I currently use an expression box to multiply two
other fields. However, because of what I am doing, I need to change the
expression box to a text box. When I do that, I can't seem to use a formula
within the text box. When it the txt box properties, it doesn't give me any
option having anything to do with formulas. How do I make the needed changes?
 
M

Michelle

Open the textbox's properities window. Under default value there is an fx
button to the right of the textbox. You can build your formula there.
For example, to multiply two fields (field1 and field2) and display the
result in field3 your formula would be field1*field2

Michelle
 
S

SeanM

When I open up the text box properties, I don't have the fx button there. Is
there something that I can do to get that option?
 
M

Michelle

Are you using SP1?

SeanM said:
When I open up the text box properties, I don't have the fx button there. Is
there something that I can do to get that option?
Click to expand...
 
M

Michelle

There are a lot of extra features in SP1 such as adding formulae to text
boxes. I would most certainly recommend upgrading.
 
P

Patrick Halstead [InfoPath MVP]

Best feature: it's free
:)

Michelle said:
There are a lot of extra features in SP1 such as adding formulae to text
boxes. I would most certainly recommend upgrading.
Click to expand...
needed changes?
 
Top