Microsoft KB Archive/25703

= Microsoft Knowledge Base =

File: Gray Fields in Form or Report
Last reviewed: October 26, 1994

Article ID: Q25703

Summary:

Gray fields in a form or report in Microsoft File mean that those fields do not match the fields currently in the data file. If fields exist in the data file, but not in the form just opened, they will appear below the hide line in the form window. The "gray field" phenomenon can be generated when an existing form is opened into a new data file.

Gray fields in a form produce gray fields in a report. A report with gray fields cannot be printed or previewed. Moving the gray fields to the Not Shown area or clearing the fields allows the report to be generated.

If you want the gray fields in the form to be part of the data file, do the following to reformat the gray fields:


 * 1) Select the gray fields from the form window.
 * 2) From the Form menu, choose Format Field.
 * 3) Change the formats if desired.
 * 4) Click the OK button.

File formats the gray fields and adds them to the data file. In the form window, the fields are no longer gray.

If these steps do not eliminate the gray fields in the report, create a new report while in a report by choosing New Report from the File menu.