Syntax Error, If Statement

[burrina]

I can't see the forest again because of the trees!
Error 2447 invalid use of (dot) ! Operator or invalid parenthesis

If [frmPayrollEntry].[Form]![txtVacHrTotal] > 364 And [frmPayrollEntry].[Form]![txtVacHrTotal] < 730 Then
       [frmPayrollEntry].[Form]![txtVacHrTotal]![lblVacHr].Caption = "1 Week"
End If

 

[CJ_London]

try replacing the dot here

[frmPayrollEntry].[

with a bang (!)

 

[vbaInet]

Most likely...

[frmPayrollEntry].[Form]![COLOR="Red"][txtVacHrTotal]![/COLOR][lblVacHr].Caption = "1 Week"

 

[CJ_London]

or should be

forms![frmPayrollEntry]![Form]![txtVacHrTotal]

 

[burrina]

I was once blind but now I see ...

Thanks,

 

[vbaInet]

I can't see the forest again because of the trees!

If you can see the trees then you're probably in the forest!