I need to compare the 1st two characters of a vehicle VIN in a report. Basically, if it starts with "1F", then I want the images property visible to TRUE.
So, the VIN is 17 characters, but I want to only evaluate the 1st two.
This is what I have, but regardless if the VIN is 1F or not, it never shows. It's default visible property is false, so if the VIN starts off with 1F, set Visible to TRUE.
Here's what I have:
Private Sub Form_Current()
If Left(VIN.Value, 2) = "1F" Then
Me.Image149.Visible = True
End Sub
I also tried to set visible to true and added:
Else
Me.Image149.Visible = False
I've done this before, but only with Yes/No type controls. Perhaps I have the function 'Left' incorrect? I received no errors.