Formulas

[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?

 

[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

 

[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?

 

[Michelle]

Are you using SP1?

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?

 

[SeanM]

I'm not. Do I need to?

Are you using SP1?

 

[Michelle]

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

 

[Patrick Halstead [InfoPath MVP]]

Best feature: it's free

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

needed changes?

 

[Tafe Riller]

How do I repeat a constant a repeating cell in a list. What is the symbol?