Browse and Paste Data Dialog Box
Use the Browse and Paste Data dialog box to preview the data type, length, and content of any field and to paste a value into your formula or selection criteria.
This dialog box appears when you click the Browse Data button in the Formula Editor Dialog Box. The source of the field (alias) and the field name appear as the title for the dialog box.
| Type | The data type for the field (string, number, and so on). |
| Length | The field length that is defined for the specified data type. |
| Scroll Box | A list of field values appears in the scroll box.
When you browse a field, by default you see the first 500 unique values of the field. You can change this for the current report by clearing the Select Distinct Data for Browsing option in the Report Options dialog box. If Select Distinct Data for Browsing is not selected, browsing returns the unique values in the first 500 records. Note Since most SQL servers do not support selecting distinct records for long data types such as memo and blob fields, selecting and browsing distinct records are not supported for such fields. |
| Paste Data | Click the Paste Data button to paste the value into your formula.
If you fail to connect to a database because it is unavailable or password-protected, you can still browse on saved data. |