i was recently working on a simple dataentry form in ms access which was accessing the table,which is linked to a excel sheet. where i had a first column of type Date/time( Column Name : AllocationTime). I have around 100 rows which has the value '1/14/2010 11:30:38 PM' for all the *100 row*s. I bonded this column to a Combo box, when i pull down the drop drown list of combo box, it showed me this value '1/14/2010 11:30:00 PM' , note that seconds is not considered.
Now when i accessed combobox.text property for filtering the records in recordset , it is obvious it will not result the rows as Allocationtime is not matching.
Has any one came across this problem, I don't know whether i did some mistake or it is a bug in combo box .