Default Calue for Time/Date Field

[JHNielson]

I have a from wiht an unbound text box. It is formatted as Short-Date.
I want the users to enter dates in the text box, but I want the default value to be 1/1/2000.

When I put in 1/1/2000 as the default date, when I open the form the date field shows 12/30/1899.

Further, when I clock on the box, the field jumps to 12:00:43 PM.

It looks like it has a time value stored.

Any suggestions on how to fix this?


Thanks

[ADezii]

I have a from wiht an unbound text box. It is formatted as Short-Date.
I want the users to enter dates in the text box, but I want the default value to be 1/1/2000.

When I put in 1/1/2000 as the default date, when I open the form the date field shows 12/30/1899.

Further, when I clock on the box, the field jumps to 12:00:43 PM.

It looks like it has a time value stored.

Any suggestions on how to fix this?


Thanks

Try specifying the Default Value as: #1/1/2000#

[pks00]

try doing it in code. Use the form load event so it gets set when the form loads


private sub Form_Load
Me.mydatefield.value = #1/1/2000#
end sub