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 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.