HELP!! Runtime error 2465

[crowee]

Private Sub Form_Current()
'For full-time position, display a message
'and the wage field value in red
'For all other positions, display the wage field value
'in black without a message
If [Hours/Week] >= 40 Then
[FullTimeMsg].Visible = True
[Wage].ForeColor = 255
Else
[FullTimeMsg].Visible = False
[Wage].ForeColor = o
End If

End Sub

When I run this I get the runtime Error 2465 Microsoft can't find the field '|' referred to in your expression.

I am so stumped and I have no idea what to do. Am Lost and need help !!!!!!!!!!
Thanks

 

[crowee]

When I debug it comes up highlighting under
Else
[FullTimeMsg].Visible = False
This statement is highlighted. What could be wrong

 

[jiqjaq]

Try using parentheses () rather than brackets [] around the Hours/Weeks. Access doesn't always highlight the actual problem.

 

[crowee]

when I do that I get a runtime error 6 overflow

 

[jiqjaq]

Sorry, I thought Hours/Week was a calculation, not a field name. It's an invalid field name. You can't use "/" as a field name character. Change it to HoursPerWeek.