To print the FIELD DESCRIPTIONS (status bar text):
I sure hope ACCESS fixes the lack of ability to print out the FIELD DESCRIPTIONS in version 2.0, but in case they don't, here's a crude work around. This allows you to print a cross index booklet that matches the FIELD names with their DESCRIPTIONS.
First, get ANALYZER running by following the instructions in the PSSKB.TXT file in your ACCESS directory. Then do the following insane procedures.
Use the Form Wizard to build a form using a tabular design based on the original table. Select all fields from the table to appear on the form.
Go to form design view and delete the labels of the text (in Form Header) but leave the data below in Detail. Circle the objects and press delete. Save the form to a unique name "Test".
Run the analyzer on the original table and "Test".
Go to Properties and select ControlSource and StatusBarText.
This will create the @TableDetails table the @FormControls table and the @FormProperties table.
Open the @FormControls table in design view and change OLE objects, Memo fields, Pictures to type text.
Build a query using the @TableDetails and @FormControls tables.
Perform a join on @TableDetails.Name and @FormControls.ControlSource.
Drag the Name field from @TableDetails box down to the first query position and drag the StatusBarText field from the @FormControls box down to the second position.
Run the query ! Now you have it ! Enjoy, John Bercik
