Add a comment to a query (ADP)

 Note   The information in this topic applies only to a Microsoft Access project (.adp).

You can document a view, user-defined function, or single statement stored procedure by adding a comment to it. You can enter a comment in a property page.

  1. In the Database window, click Queries Button image under Objects, click the view, user-defined function, or single statement stored procedure you want to open, and then click Design on the database window toolbar.
  2. Right-click in the Query Designer, then select Properties from the shortcut menu.
  3. Enter the comment in the SQL Comment field.

Notes

  • You should avoid entering the two-character strings "/*" and "*/" within your comments.
  • If you change the type of query (for example, from a SELECT query to an UPDATE query), the query’s comment is deleted.
 
 
Applies to:
Access 2003