Working with table and field properties

Paradox lets you change the appearance of tables by formatting text, general table attributes, and the properties of individual fields. For example, you can change font size and the background color of a field. You can also save the properties that you use most often and apply them to other tables.

In this section, you'll learn about

  formatting text in a table
  
  aligning text and changing line spacing in a table
  
  changing table grid properties
  
  changing table field color
  
  formatting table record markers
  
  formatting data dependent ranges in table fields
  
  setting field properties
  
Formatting text in a table

You can format the font, style, and size of the text of any heading or field in a table. You can also change the color of text.

To format the text in a table

1	Right-click a field, and click Properties.

2	Click the Font tab.

3	Choose a font from the Font list.

4	Choose a font style from the Font style list.

5	Choose a font size from the Size list.

6	Click Apply.

You can also	

Change the text script	Choose a script type from the Script list box.

Underline text	Enable the Underline check box.

Strike through text	Enable the Strikeout check box.

Tip

  You can format table heading text by right-clicking a heading.
  
To change the color of text in a table

1	Right-click a field, and click Properties.

2	In the Properties dialog box, click the Font tab.

3	Click a color on the color palette.

4	Click Apply.

Tip

  You can apply a custom color to text. For more information about applying a custom color, see "To apply a custom field color."
  
  You can change the color of text in a table heading by right-clicking a heading.
  
Aligning text and changing line spacing in a table

Alignment refers to the linear placement of text in a field or a heading. You can align text horizontally at the left, center, or right of a column or vertically at the top, center, or bottom of a row. You can also align text vertically with the top, middle, or bottom of the row. In addition, you can align and change the line spacing of text in a formatted memo field.

To align text in a table field

1	Right-click a field, and click Properties.

2	Click the Font tab.

3	Click the Alignment tab.

4	In the Horizontal area, enable one of the following options:

  Left-aligns text with the left side of the column
  
  Center-centers text horizontally within the column
  
  Right-aligns text with the right side of the column
  
5	In the Vertical area, enable one of the following options:

  Top-aligns text with the top of the row
  
  Middle-centers text vertically within the row
  
  Bottom-aligns text with the bottom of the row
  
Tip

  You can align text of a table heading by right-clicking a heading.
  
To align text in a formatted memo field

1	In Edit mode, double-click a formatted memo field.

2	Select the text you want to align.

3	Right-click, and click Properties.

4	Click the Text tab.

5	Enable one of the following options:

  Left-aligns text with the left side of the column
  
  Center-centers text horizontally in the column
  
  Right-aligns text with the right side of the column
  
  Justify-aligns text with both sides of the window
  
If you want to wrap text automatically in the formatted memo field, enable the Wrap text check box.

6	Click Apply.

Note

  If you change the alignment in a formatted memo field, the change is applied only to that memo.
  
To change line spacing in a formatted memo field

1	In Edit mode, double-click a formatted memo field.

2	Select the text whose line spacing you want to change.

3	Right-click, and click Properties.

4	Click the Text tab.

5	In the Spacing area, enable a spacing option.

Changing table grid properties

Paradox lets you display the gridlines for the table heading, columns, and rows. You can also change the gridline color. In addition, you can change the grid color.

To display gridlines

1	Click Format  Properties  Grid.

2	Click the Gridlines tab.

3	In the Position area, enable any of the following check boxes:

  Heading lines-displays the gridline below the table heading
  
  Column lines-displays the gridlines between the columns of the table
  
  Row lines-displays the gridlines between the rows of the table
  
4	Click Apply.

Note

  By default, Paradox does not display heading, column, or row gridlines.
  
To change grid line color

1	Click Format  Properties  Grid.

2	Click the Gridlines tab.

3	Click a color on the color palette.

You can also	

Change the gridline style	Choose a line style from the Line style box.

Change gridline spacing	Choose a spacing option from the Spacing list box.

Move the heading gridline from below heading text to behind heading text	Enable the Query look check box.

To change grid background color

1	Click Format  Properties  Grid.

2	Click the General tab.

3	Click a color on the color palette.

4	Click Apply.

Note

  For more information about creating custom colors, see "To apply a custom field color."
  
Changing table field color

You can change the color of any field in a table. For example, you may want to apply a contrasting color to a field to highlight the data. You can also create a custom color and apply it to a field.

To change field color

1	Right-click a field, and click Properties.

2	Click a color on the color palette.

3	Click Apply.

To apply a custom field color

1	Right-click a field, and click Properties.

2	Click an empty cell on the color palette.

3	Click Add custom color.

4	In the Custom color dialog box, enable one of the following options:

  RGB-applies the RGB color mode, which is composed of red (R,) green (G), and blue (B) values
  
  HSV-applies the HSV color mode, which is composed of hue (H) and saturation (S) values (V)
  
  CMY-applies the CMY color mode, which is composed of cyan (C,) magenta (M), and yellow (Y) values
  
5	Move any of the color sliders.

6	Click OK.

7	In the Properties dialog box, click Apply.

Tip

  You can apply a system color to a field in the Custom color dialog box by clicking the System tab, and choosing a color from the System list.
  
Formatting table record markers

The record marker is a horizontal line that displays beneath the current record in a table, making it easier for you to scroll through table records. You can display a record marker in a table. You can also modify table marker properties, such as marker color and line style.

To display a record marker

1	Click Format  Properties  Grid.

2	Click the Record marker tab.

3	Enable the Show record marker check box.

Note

  By default, Paradox does not display the record marker.
  
To modify record marker color

1	Click FormatPropertiesGrid.

2	Click the Record marker tab.

3	Click a color on the Line color palette.

4	Click a line style on the Line style palette.

5	Click Apply.

Formatting data dependent ranges in table fields

Paradox lets you make the color of a field depend on the data it contains. For example, you can create a table of donors for a certain charity and use three different colors to differentiate between the donors who gave less than $100, those who gave $100 to $500, and those who gave more than $500.

To specify a data-dependent color for a table field

1	Right-click a field, and click Data dependent.

2	Click New range.

3	In the Range include values area, type a value in the first range value box.

4	Enable one of the following operator options:

  Equals
  
  Greater than
  
  Greater than or equal to
  
5	In the And area, type a value in the second range value box.

6	Enable one of the following operator options:

  Less than
  
  Less than or equal to
  
7	Click Set properties.

8	In the Properties dialog box, click a color on the color palette.

You can also	

Specify font properties for text.	Click the Font tab. Specify any font properties.

Preview the properties you specified.	Click Apply changes.

Notes

  The field types whose display you can make data dependent are the following: alpha,gloss_alph number,gloss_nfield short,gloss_snumb long integer,gloss_longinteger date,gloss_datefield time,gloss_timef timestamp,gloss_timestamp logical,gloss_logicalf autoincrement,gloss_autoinc and moneygloss_moneyf field types, as well as dBASE character, number, float number, date, and logical field types.
  
  The properties of a data-dependent range override the properties specified for a column. If, for example, you choose a blue background color for a column, any records that fall within a data-dependent range are not affected. These records continue to use the background color for the range, rather than for the column.
  
To remove a data-dependent range

1	Right-click a field that has a data dependent range, and click Data dependent.

2	Choose a range from the Ranges list.

3	Click Remove.

Setting field properties

Paradox lets you save table, field type, and default field type properties, which saves the appearance of a table and its fields. For example, you can save the properties that you use most often, such as displaying number fields in decimal format displaying text in blue. Paradox saves the properties in a file with a .tv extension. For example, the properties you define for the customer.db table are saved in customer.tv.

You can also create a default properties file by creating a table or copying a table customized with the settings you want to use as defaults.

Paradox also lets you restore table properties to those in place when you opened the table. You can also delete table properties.

To save table properties

  Click Format  Properties  Save.
  
Note

  If you close a table window without saving property changes, you are prompted to save the changes. This allows you to save all the property changes you make in a table window, including property changes to individual fields.
  
To save default field properties

1	In your private directory, create a table that includes one of each available field types, and save this table as default.db.

2	Click File  Open  Table.

3	Choose the drive and folder where default.db is stored.

4	Double-click the filename.

5	In Edit mode, right-click a field, and click Properties.

6	Set the properties for the field type.

7	Click Format  Properties  Save.

This saves the property settings in the default.tv file.

Note

  If you work with a table that does not have its own .tv file, Paradox applies the settings from default.tv. Table-specific .tv files override the settings in default.tv.
  
To save default field properties by copying

1	Open a table.

2	Create a table that includes one of each available field types.

3	Click Format  Properties  Save.

4	Copy the table to default.db in your private directory.

Paradox copies the table's .tv file, as well as the .db file, and uses the .tv file's default property settings.

Note

  For more information about copying tables, see "Copying tables."
  
Tip

  If you are running out of disk space, you can delete default.db, and any other default files, such as .px or .val files, that were copied along with the table. However, do not delete default.tv. When you delete a table's unique .tv or .tvf property file, Paradox automatically uses default property settings.
  
To restore table properties

  Click Format  Properties  Restore.
  
To delete table properties

1	Click Format  Properties  Delete. 




