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. The source of the field (alias) and the field name appear as the title for the dialog 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.
If you fail to connect to a database because it is unavailable or password-protected, you can still browse on saved data.
Report Options Dialog Box | Accessing and Adding Data | Performing Report Calculations