Export (0) Print
Expand All

DeleteReportControl Method [Access 2003 VBA Language Reference]

Office 2003

The DeleteReportControl method deletes a specified control from a report.

expression.DeleteReportControl(ReportName, ControlName)

expression Required. An expression that returns one of the objects in the Applies To list.

ReportName  Required String. A string expression identifying the name of the form or report containing the control you want to delete.

ControlName  Required String. A string expression identifying the name of the control you want to delete.

Remarks

The DeleteReportControl method is available only in form Design view or report Design view, respectively.

Note  If you are building a wizard that deletes a control from a form or report, your wizard must open the form or report in Design view before it can delete the control.

Example

The following example creates a form with a command button and displays a message that asks if the user wants to delete the command button. If the user clicks Yes, the command button is deleted.

Sub DeleteCommandButton()
    Dim frm As Form, ctlNew As Control
    Dim strMsg As String, intResponse As Integer, _
         intDialog As Integer

    ' Create new form and get pointer to it.
    Set frm = CreateForm
    ' Create new command button.
    Set ctlNew = CreateControl(frm.Name, acCommandButton)
    ' Restore form.
    DoCmd.Restore
    ' Set caption.
    ctlNew.Caption = "New Command Button"
    ' Size control.
    ctlNew.SizeToFit
    ' Prompt user to delete control.
    strMsg = "About to delete " & ctlNew.Name &". Continue?"
    ' Define buttons to be displayed in dialog box.
    intDialog = vbYesNo + vbCritical + vbDefaultButton2
    intResponse = MsgBox(strMsg, intDialog)
    If intResponse = vbYes Then
        ' Delete control.
        DeleteControl frm.Name, ctlNew.Name
    End If
End Sub
		


Applies to | Application Object



Show:
© 2014 Microsoft