Why would you create a function in a standard module?

A) To embed the function in the open form
B) To use the function in any query, form, or report in the database
C) To prepare for converting the function to a macro
D) To avoid having to use VBA syntax

Question

Maddie Baird · Accepted Answer

Final Answer : B, Explanation :  Creating a function in a standard module allows it to be used in any query, form, or report in the database, providing flexibility and reusability of code.

Why would you create a function in a standard module?

A) To embed the function in the open form
B) To use the function in any query, form, or report in the database
C) To prepare for converting the function to a macro
D) To avoid having to use VBA syntax

Definitions

Learning Objectives

Learning Objectives

Related questions

Why would you create a function in a standard module?A) To embed the function in the open formB) To use the function in any query, form, or report in the databaseC) To prepare for converting the function to a macroD) To avoid having to use VBA syntax

Definitions

Learning Objectives

Learning Objectives

Related questions

Why would you create a function in a standard module?

A) To embed the function in the open form
B) To use the function in any query, form, or report in the database
C) To prepare for converting the function to a macro
D) To avoid having to use VBA syntax