What is the syntax to format number output?

 Format(<value>, "<formatting convention>")
'example - outputs 2
decimalNum = 2.31321
Msgbox Format(decimalNum, "0")

 

Advertisements

What is the syntax to return the index of an active multipage?

Me.<multi-page name>.Value
#returns an integer value
'example for multipage named "mtp"
Private Sub mtp_Change() 'called whenever user goes to new multipage
   If Me.mtp.Value = 1 Then 'if user opens the "Show Guest List" page
        Call loadGuestLists
   End If
End Sub