Viewers

The object that you are going to test must exist. To test all viewers, open one of your forms, that is bound to a recordset and contains bound controls. Thus, you have all types of objects, HAT can view: Form, Recordset, Control and Field.

Form Viewer

There are two methods to activate the Form Viewer:

1. Press the button Form Viewer in HAT's main window. Choose your form from the combobox in the form viewer. If you need to inspect any subform, the names of subform controls are shown in the next combobox which is named Subform Controls.
2. Open the debug window and enter one line like this:
   HAT_frmView frmXYZ
   where frmXYZ is an expression of type Form [an Access Basic   variable declared like Dim frmXYZ as Form or an expression like Forms("MyForm")]

TIP: You may copy the Text " HAT_frmView frmXYZ" from the ToolTip in HAT's main window and paste it into the debug window.

Using one of the methods explained above, you'd get the Form Viewer, showing you the information about your form. First, the name of your form is displayed. Then, a list of the controls that are contained in your form is shown. Finally a list of the properties is presented.

If your form is bound to a recordset, then you may choose the RecView button to see the Recordset Viewer (see below)

If you push the button FldView or double-click any line of the the Controls list, you'll go to the Field Viewer.

If you push the button CtlView, you'll go to the Control Viewer

Control Viewer

There are three methods to activate the Control Viewer:

1. In the Form Viewer select a control from the Controls list. Press the button CtlView.
2. In the Form Viewer double-click a selected control in the Controls list.
3. Open the debug window and enter one line like this:
   HAT_ctlView ctlXYZ
   where ctlXYZ is an expression of type Control [an Access Basic variable declared like Dim ctlXYZ as Control or an expression like Forms!MyForm!MyControl]

Using one of the methods explained above, you'll get the Control Viewer, showing you the information about your control. The name of selected control and the list of properties are displayed in this form.

You may doubleclick the list of properties to edit the property's value.

If your control is bound to a database field, you may push the FldView button to go to the Field Viewer.

Recordset Viewer

There are two ways of activating the Recordset Viewer:

1. Press the button RecView in the Form Viewer.
2. Open the debug window and enter one line like this:
   HAT_recView recXYZ
   where recXYZ is an expression of type Recordset [an Access Basic variable declared like Dim recXYZ as Recordset or an expression like Forms!MyForm.Recordsetclone]

TIP: You may interrupt your Access Basic code by setting a breakpoint and then inspecting your recordset variables.

The Recordset Viewer shows you the information about the selected recordset.

At first, the name of selected recordset is displayed. Then, a list of the fields that it contains is shown. Third, you can see the list of the recordset's properties.

In the text field AbsolutePosition you can obtain the number of the active row. You may even change this number and the active row will change as well, when you leave the text field.

You may use the Navigation Buttons to select the first, previous, next and last row, respectively.

If you've pushed the Find button, the Navigation Buttons work together with the text you supplied below the Find button as FindFirst, FindPrevious, FindNext and FindLast, respectively. The checkbox NoMatch shows the result of the find operation.

As you see, the Recordset Viewer is a little bit more than a viewer - you may even change the active row of your recordset.

Field Viewer

There are three ways of activating the Field Viewer:

1. In the Recordset Viewer double-click a control of the Fields list.
2. In the Control Viewer press the button FldView
3. Open the debug window and enter one line like this:
   HAT_fldView fldXYZ
   where fldXYZ is an expression of type Field [an Access Basic variable declared like Dim fldXYZ as Field or an expression like Forms!MyForm.Recordsetclone!MyField]

Using one of the methods explained above, you'll get the Field Viewer, showing you the information about your field. The name of the selected field and the list of its properties are displayed in this form.