Spread 8.0 Documentation
Spread Designer
Support Options

Glossary Item Box

Spread Designer


To size columns in bound sheets

Notes:
  • To set data-binding properties, the Spread Designer view must be the active view. You cannot set data-binding properties for a sheet that you open in the Spread Designer (that is, by choosing Open from the File menu).
  • If you bind columns to data fields using the Spread Designer and then change the record source for the data control, you must refresh the data control (for example, run your project) before resetting data fields with the Spread Designer. Unless the data control is refreshed, the new data fields will not be reflected in the Spread Designer.

  1. Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
  2. Open the Spread Designer.
  3. From the Sheet menu, choose Data Binding.
    The Data Binding dialog box appears:

  4. To have the columns automatically sized based on the data in the database fields, select one of the following from the Size Column to Data drop-down list box:
    • Max Column Width to size the column to the length of the longest string in the field
    • Best Guess to size the column to the length of the database field.

      Note: If the bound cells are edit cells, be aware that the default setting of the TypeMaxEditLen property is 60 characters. You must reset the TypeMaxEditLen property at run time to 255 characters to accommodate a text field in the bound database.

  5. If you do not want the columns automatically sized based on the data in the database fields, from the Size Column to Data drop-down list box choose Off and if you want, size the columns manually.
    For instructions for sizing columns, see Sizing Columns and Rows.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.