Convert macros to Visual Basic

Microsoft Office Access 2003

event procedures or modules that perform equivalent actions by using Visual Basic code. You can convert macros on a form or report, or you can convert global macros that aren't attached to a specific form or report.

ShowConvert macros on a form or report

  1. Open the form or report in Design view.
  2. On the Tools menu, point to Macro, and then click Convert Form's Macros To Visual Basic or Convert Report's Macros To Visual Basic.

ShowConvert global macros to Visual Basic

  1. In the Database window, click Macros Button image under Objects.
  2. Click the name of the macro you want to convert.
  3. On the File menu, click Save As.
  4. In the Save As dialog box, click Module in the lower text box and click OK.
  5. In the Convert Macro dialog box, select the options you want, and click Convert.