I have the following Code Which Results in You Entered an Expression Which has No Value
Private Sub Report_Load()
Dim sContNo As String
sContNo = "Buyer" & " " & "GAIE/IMP/" & Format(Me.ContID.Value, "000")
Me.Report.Caption = sContNo
End Sub
There is No Problem when i Compiled, the Problem is only when i run the Access Report.
Can anyone Help.
Private Sub Report_Load()
Dim sContNo As String
sContNo = "Buyer" & " " & "GAIE/IMP/" & Format(Me.ContID.Value, "000")
Me.Report.Caption = sContNo
End Sub
There is No Problem when i Compiled, the Problem is only when i run the Access Report.
Can anyone Help.