Hi,

I have an application which is an MS Access 2000 application. In one of the
forms I am using the Windows Date and Time picker control. However the form
must work in both the datasheet view and form view and the date picker does
not show up in the datasheet view. To fix this problem I added a hidden text
field which is linked to the same column as the date time picker. So on the
form view, the user uses the data picker control and in datasheet view, the
user enters the values in the text field.

The error occurs when the user switches between datasheet view and form
view. The error message is "An error occurred in a call to the Windows Date
and Time picker control".

Please help. I think if I was able to get the date and time picker control
to show up in data sheet view and removed the hidden text box the error
would be fixed. However, I can't figure how to do it.

Thanks

Dave Hall

Sorry but the Date Time Picker can not (to the best of my knowledge) be used in dataview. And I use it a lot!

DES

Is there another control which is part of ACCESS 2000 that I could use instead of the date and time picker?