• 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
08 Nov 2010OL2003 - Initial Value Field - Too Small.PCTperformance
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)