I tried your suggesstion and am getting a Run-Time error 2763.
I messed with it a bit with a new database, and it worked fine. After tinkering, I discovered the following:
An error is returned if the DTPicker is on a non-topmost tab in a tab control!!
Try it. Make blank form. Drag a DTPicker on it, and put a Me.DTPicker0.Value = Now() statement in the Form_Load event.
Make a tab control, put the DTPicker on the top-most tab.
Put the DTPicker on the next tab down.
Man, I'm getting sick of Microsoft's buggy as hell controls! It seems I'm finding this kinda stuff every other week! Somehow I manage to discover the 1 instance in 100 where the stupid control fails to do what's expected!
If anyone can help me out of this pickle, I'd be grateful, but if not, thanks for trying.