Access 2003 Type Mismatch Error
Posted on 2012-03-27
Can anyone tell me why I get this error, "The expression On Current you entered as the event property setting produced the following error: Type mismatch." I get the error when the program is opened on a computer with only the Access 2003 runtime installed. On computers with full version Access all works as expected.
This is the code I have in the On Current event.
If Me.txtD36 <= 3 Or Me.txtD36 >= 87 Then
Me.txtD36.BackColor = 65280
Me.txtD36.ForeColor = 0
Me.txtD36.BackColor = 2366701
Me.txtD36.ForeColor = 16777215
Any help appreciated.