Displaying and hiding fields in Table View

Displaying and hiding fields in Table View

After you define a field, you can use Layout mode to place the field on any layout (assuming you have access privileges to do so). See Placing and removing fields on a layout. When you are working in Table View, you can display additional fields that are not on the current layout and hide fields that show in Table View.

Note When you display existing fields that are not on the current layout in Table View, they are not added to the layout so they do not appear in any view other than Table View. Likewise, if you hide fields in Table View, fields are not removed from the layout and are visible when users view the layout in other views.

To display fields in Table View:

1.

In Browse mode, right-click the table column heading, and choose Table View > Modify or click Modify in the status toolbar.

The Modify Table View dialog box appears, listing the fields currently displayed in Table View.

2.

You can use the Modify Table View dialog box to do the following:

To

Do this

Hide fields

Clear checkboxes for the fields you want to hide in Table View.

Reorder columns

Drag the next to a field to reorder fields in the list and in Table View.

Display additional fields

Click to open the Add Fields dialog box, then choose a field to add and click OK. To choose a field in another table, choose the table from the list above the list of fields, then choose a field. To define a new field, choose Manage Database from the list.

Remove fields you added

Select one or more fields and click .

3.

Click OK to save changes or click Cancel to discard changes.

Notes

•

Fields on the current layout are marked with a lock icon in the Modify Table View dialog box, indicating they can’t be removed from the list. You can prevent these fields from displaying in Table View by clearing their checkbox.

•

When you add fields (columns) in Table View, the style and point size of the font are determined by the layout theme’s default font settings. If you want to change the font characteristics for a field, you must use Layout mode to format the field.

Related topics

Viewing records as a form, list, or table

To	Do this
Hide fields	Clear checkboxes for the fields you want to hide in Table View.
Reorder columns	Drag the next to a field to reorder fields in the list and in Table View.
Display additional fields	Click to open the Add Fields dialog box, then choose a field to add and click OK. To choose a field in another table, choose the table from the list above the list of fields, then choose a field. To define a new field, choose Manage Database from the list.
Remove fields you added	Select one or more fields and click .

Was this topic helpful? Send feedback.