Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can customize the format for grids in various ways.
Using Conditional Formatting in Grids
Special formatting in a grid can make it easier for a user to scan through the records in the grid and locate certain information. To provide conditional formatting, use the dynamic font and color properties of a column.
For example, you can add a grid to a form and set the ColumnCount property to 2. Set the ControlSource property of the first column to orders.to_name and the ControlSource property of the second column to orders.order_net. To display order totals less than 500.00 with a forecolor of black and order totals greater than or equal to 500.00 with a foreground color of red, include the following line in the grid's Init event code:
THIS.Column2.DynamicForeColor = ;
"IIF(orders.order_net >= 500, RGB(255,0,0), RGB(0,0,0))"
Common Grid Properties
The following grid properties are commonly set at design time.
Property |
Description |
|---|---|
The foreign key of the child table that is joined with the primary key of the parent table. |
|
Number of columns. If ColumnCount is set to - 1, the grid has as many columns as there are fields in the grid's RecordSource. |
|
The parent table for child records displayed in the grid. |
|
The data to be displayed in the grid. |
|
Where the data displayed in the grid comes from: a table, an alias, a query, or a table selected by the user in response to a prompt. |
Common Column Properties
The following column properties are commonly set at design time.
Property |
Description |
|---|---|
The data to be displayed in the column. This is often a field in a table. |
|
If Sparse is set to true (.T.), controls in a grid are displayed as controls only when the cell in the column is selected. Other cells in the column display the underlying data value in a text box. Setting Sparse to true (.T.) allows faster repainting if a user is scrolling through a grid with a lot of displayed rows. |
|
Which control in the grid is active. The default is Text1, but if you add a control to the column, you can specify it as the CurrentControl. |
Note
The ReadOnly property of a control inside the column is overridden by the ReadOnly property of the Column. If you set the ReadOnly property of the control in a column in the code associated with the AfterRowColChange event, the new setting will be valid while you are in that cell.
See Also
Tasks
How to: Set Up a One-to-Many Form Using the Grid Control
How to: Make Controls Easier to Use
Concepts
Controls and Objects Created in Earlier Versions
Reference
Controls for Manipulating Rows of Data