M morlan Registered User. Local time Today, 02:26 Joined Apr 23, 2003 Messages 143 Mar 23, 2004 #1 If me.Control IS Between Value and Value Just a quick one. I need to check if control's value is between 10 and 20. How do I do this? If me.Control IS Between Value and Value
If me.Control IS Between Value and Value Just a quick one. I need to check if control's value is between 10 and 20. How do I do this? If me.Control IS Between Value and Value
dcx693 Registered User. Local time Yesterday, 21:26 Joined Apr 30, 2003 Messages 3,263 Mar 23, 2004 #2 If Me.Control >= 10 And Me.Control <= 20 Then 'do this End If "Between" is used in criteria expressions. It's not a VBA operator.
If Me.Control >= 10 And Me.Control <= 20 Then 'do this End If "Between" is used in criteria expressions. It's not a VBA operator.