- Subject: OL2003 - Initial Value Field - Too Small
- Author: PCTperformance
- Date: 08 Nov 2010
- References:
I have a custom OL2003 Form that is used as an order form. It has a
ten item capacity; each Item has a Qty, Item, and Price field.
I also have a tabbed page on the form with only one field named
Summary. I would like the Summary Field to show the information
entered on the main form (first tab). The Summary field is used by
the receipient to cut-and-past the essential information into another
message.
I am trying to use the formula below:
"For:"&[Dept]&Chr(13)
&"By:"[Required]&Chr(13)
&""&[Qty-0]&Chr(9)&[Item-0]&Chr(9)&[Price-0]&Chr(13)
&""&[Qty-1]&Chr(9)&[Item-1]&Chr(9)&[Price-1]&Chr(13)
&""&[Qty-2]&Chr(9)&[Item-2]&Chr(9)&[Price-2]&Chr(13)
&""&[Qty-3]&Chr(9)&[Item-3]&Chr(9)&[Price-3]&Chr(13)
&""&[Qty-4]&Chr(9)&[Item-4]&Chr(9)&[Price-4]&Chr(13)
&""&[Qty-5]&Chr(9)&[Item-5]&Chr(9)&[Price-5]&Chr(13)
&""&[Qty-6]&Chr(9)&[Item-6]&Chr(9)&[Price-6]&Chr(13)
&""&[Qty-7]&Chr(9)&[Item-7]&Chr(9)&[Price-7]&Chr(13)
&""&[Qty-8]&Chr(9)&[Item-8]&Chr(9)&[Price-8]&Chr(13)
&""&[Qty-9]&Chr(9)&[Item-9]&Chr(9)&[Price-9]&Chr(13)
It seems to work, except for the fact that the
Properties>Value>Initial Value field is not big enough to take the
whole formula. Even though the window is big enough to contain the
whole formula, the formula gets truncated when saved. I can only get
the first two or three items.
Is there a way to make the Initial Value field take a larger formula
string? Or, is there a better formula to accomplish the same thing?
Thanks Much,
JimF