> Control Date value not working......

[stretch66]

Hi,

Am trying to get this to work but for some reason it doesn't. Can anyone tell me what I have done wrong please?

If Me.StartDate >= (1 / 1 / 2006) Then
Me.lblContract.Visible = True
Else
Me.lblContract.Visible = False
End If

Thanks

 

[RoyVidar]

<smile>the division 1/1/2006 equals something very small</smile>

Try with date delimiters

If Me.StartDate >= #1 /1/2006# Then

Seeing you're from UK, in the VBE Access is most interested in US dates, so if you do a comparision against say 1/12/2006, where you intend it to be first of december, Access will most likely interpret it as 12. of january

 

[stretch66]

Thanks Roy that worked!!