Hello,

I need to write some VBA code to clear a label in FORM LOAD.

To clear a label in the form load, you can simply write

Me.lblMyLabel.Caption = ""

but this may cause problems. I don't know if labels can be set to zero length; so you can hide it entirely but not clear it, e.g.

Me.lblMyLabel.Visible = False

Replace "lblMyLabel" with the actual name of your label.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Greg thank you for your help this is what I end up doing.

Private Sub Form_Open(Cancel As Integer)
'disable editing if contract is closed
If Me.Closed.Value = True Then
    Me.AllowEdits = False
    Me.lblContractClosed.Visible = True
Else
    Me.AllowEdits = True
     Me.lblContractClosed.Visible = False
End If

'If EURO is chcked display EURO on invoice form
If Forms![Invoice Scanner].EURO = True Then
   Forms![Invoice Scanner]!InvSub.Form!CurPayIn = "EURO"

'If GBP is checked othen display GBP on nnvoice
ElseIf Forms![Invoice Scanner].GBP = True Then
       Forms![Invoice Scanner]!InvSub.Form!CurPayIn = "GBP"

'If GBP and EURO = false then display U.S. dollars
Else
Forms![Invoice Scanner]!InvSub.Form!CurPayIn = "U.S. Dollars"