Format(<value>, "<formatting convention>")
'example - outputs 2 decimalNum = 2.31321 Msgbox Format(decimalNum, "0")
Advertisements
Format(<value>, "<formatting convention>")
'example - outputs 2 decimalNum = 2.31321 Msgbox Format(decimalNum, "0")
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