I've got a simple bit of code but I keep getting an error message.
"You entered an expression that has no value.The expression may refer to an object that has no value, such as a form , report or a label control."
All I wish to do is highlight the fact that my forecast date is overdue.
Private Sub Report_Open(Cancel As Integer)
Select Case Me.Date_Forecast
Case Is < Date
Me.Date_Forecast.FontBold = True
Me.Date_Forecast.ForeColor = 255
Case Else
'don't do anything, print with normalreport font.
End Select
End Sub
Once again your help will be appreciated.
"You entered an expression that has no value.The expression may refer to an object that has no value, such as a form , report or a label control."
All I wish to do is highlight the fact that my forecast date is overdue.
Private Sub Report_Open(Cancel As Integer)
Select Case Me.Date_Forecast
Case Is < Date
Me.Date_Forecast.FontBold = True
Me.Date_Forecast.ForeColor = 255
Case Else
'don't do anything, print with normalreport font.
End Select
End Sub
Once again your help will be appreciated.