Im doing some form validation on some short time fields.
I need to test to see if the users input into Time_Start ouside the period 06:00AM to 06:00PM
The date part of the validation has to be handled separately in another field as users wont necessarily be recording the event on the day it occurs but the Start_Times and End_Time period won't vary.
The below is giving me msgbox warnings regardles of the times I enter?
I thought perhaps it was the fact I hadn't specified that the date was today but for me that doesn;t ring true as if the user is only entering a time how would Access possibly know that time related to any specific date?Code:If Me.Time_Start < ("06:30AM") Then MsgBox "msgbox warning etc....." End If If Me.Time_Start > ("06:00PM") Then MsgBox "some other warning....." End If
I have read quite a bit on dates/Times over the past few days but this is still confusing to me.