Table of contents

Report.OnActivate 属性 (访问)Report.OnActivate Property (Access)

office 365 dev account|上次更新日期: 2018/3/13
2 参与人员

设置或返回窗体或报表的属性窗口中激活框的值。读/写,字符串Sets or returns the value of the On Activate box in the Properties window of a form or report. Read/write String.


表达式OnActivateexpression. OnActivate

表达式_一个表示报表对象的变量。_expression A variable that represents a Report object.


该属性有助于以编程方式更改事件别触发时 Microsoft Access 所采取的行动。例如,在各次事件调用之间可能要根据触发事件的环境更改表达式的参数,或从一个事件过程切换到一个表达式或宏。This property is helpful for programmatically changing the action Microsoft Access takes when an event is triggered. For example, between event calls you may want to change an expression's parameters, or switch from an event procedure to an expression or macro, depending on the circumstances under which the event was triggered.

当窗体或报表获得焦点并成为活动窗口,则Activate事件时发生。The Activate event occurs when the form or report receives the focus and becomes the active window.

OnActivate值将为以下操作,具体取决于在选择生成器窗口 (通过在对象的属性窗口中激活框旁的生成按钮访问) 中所选内容之一:The OnActivate value will be one of the following, depending on the selection chosen in the Choose Builder window (accessed by clicking the Build button next to the On Activate box in the object's Properties window):

  • 如果选择表达式生成器,则值将为"=表达式",其中_表达式_是表达式生成器窗口中的表达式。If Expression Builder is chosen, the value will be "= expression", where expression is the expression from the Expression Builder window.

  • 如果选择了“宏生成器”,则该值是宏的名称。If Macro Builder is chosen, the value is the name of the macro.

  • 如果选择了“代码生成器”,则该值是“[事件过程]”。If Code Builder is chosen, the value will be "[Event Procedure]".

如果激活框为空,属性值将为空字符串。If the On Activate box is blank, the property value is an empty string.


下面的示例将激活事件与"订单输入"窗体的宏"Activate_Macro"。The following example associates the Activate event with the macro "Activate_Macro" for the "Order Entry" form.

Forms("Order Entry").OnActivate = "Activate_Macro"

另请参阅See also


报表对象Report Object

© 2018 Microsoft