Report error Run Time error 2427

T

TotallyConfused

I have combo box where I have list of months and years. When I choose
January 2009. It gives me a 2427 run time error. When I debug it takes me to:

Private Sub Detail_Format(Cancel As Integr, FormatCount As Integer)
If Me.somefield>0 Then Me.Detail.BackColor = 14408667 Else
Me.Detail.BackColor = 16777215
If me.[anotherfield] = "Followup" Then Me.Label22.Visible = False

End Sub

However, when I choose any other month I get my report in view form. Can
someone please explain and help me out?? Thank you.
 
D

Duane Hookom

I would try:
Private Sub Detail_Format(Cancel As Integr, FormatCount As Integer)
If Me.somefield>0 Then
Me.Section(0).BackColor = 14408667
Else
Me.Section(0).BackColor = 16777215
End If
If me.[anotherfield] = "Followup" Then
Me.Label22.Visible = False
End If

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 2427 - Unable to debug 0
Main Report without Data 1
Detail_Format works in Print Preview but Not When Printing 0
A general question about report recordset binding and dataavailability 7
Help with modifying report from Duane Hookom - Hook'D on Access website 2
Combo Box help (repost) 2
Check Box Mental Block 5
run-time error 2427 2

Top