• Home
 · 
• Miscellaneous
 · 
• Is Form Loaded?

Is Form Loaded?

This function will tell you if your form is loaded (instantiated) or not. If you use the form's "Visible" property to determine this, the form is instantiated if it's not already loaded. This results in the form's "Load" event being executed unnecessarily. This function has none of the above overheads...

Inputs
Syntax: If IsLoaded("frmTest") Then...

Returns
True (loaded) or False (not loaded)

Rate Is Form Loaded?

• 1
• 2
• 3
• 4
• 5

(3(3 Vote))

Public Function IsLoaded(sForm As String) as Boolean
Dim Frm As Form
 
' Loop through the Forms collection looking
' for the form of interest...
 For Each Frm In Forms
 If Frm.Name = sForm Then
  ' Found form in the collection
  IsLoaded = True
  Exit For
 End If
 Next
End Function