Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Active Form formatting is defined directly in the worksheet containing the form. There are default formats set by TM1 but they can be changed.
Active Form formatting is defined via a format range which is hidden within the Active Form worksheet. This hidden range is revealed by clicking on Active Form and then selecting Show Format Area.
Active Forms must have the default formatting defined in rows 1 to 8 where row 1 will always have the Begin Format Range label and row 8 will always have the End Format Range label:
With the formatting range, rows 2 through 7 will be the actual formatting definitions.
Column A (in rows 2 through 7) contains the Format Definition labels used to format the Active Form. These labels can be numbers, letters, or string values. For each data row in the Active Form, column A contains a value that determines which format definition should be applied to the row.