Table of contents
Collapse the table of content
Expand the table of content

Module.AddFromString Method (Access)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

The AddFromString method adds a string to a Module object. The Module object may represent a standard module or a class module.


expression. AddFromString( ** String** )

expression A variable that represents a Module object.


NameRequired/OptionalData TypeDescription
StringRequiredStringThe information that you want to add to the module.

Return Value



The AddFromString method places the contents of a string after the Declarations section and before the first existing procedure in the module if the module contains other procedures.

In order to add a string to a form or report module, the form or report must be open in form Design view or report Design view. In order to add a string to a standard module or class module, the module must be open.


This example creates a new form and adds a string and the contents of the Functions.txt file to its module. Run the following procedure from a standard module:

Sub AddTextToFormModule() 
 Dim frm As Form, mdl As Module 

 Set frm = CreateForm 
 Set mdl = frm.Module 
 mdl.AddFromString "Public intY As Integer" 
 mdl.AddFromFile "C:\My Documents\Functions.txt" 
End Sub

See also


Module Object

© 2018 Microsoft