default date for unbound textbox

[cyberpac9]

i have an unbound form where users can enter as much or as little as they'd like to search the database. i'd like to have default values for two unbound textboxes for initial date and ending date. i was wanting to put in 1/1/1999 for initial and 1/1/2050 (or another high number) for ending date. however, when i put those values in the Default Value property for each textbox, it changes to 12/30/1899..for both the initial and ending dates...how do i get my dates to show up?

 

[cyberpac9]

ok....for the end date i think i can get away with =Now()...however, it uses the time as well...is there a way to just use Now() for month, day and year? also, still need a solution for beginning date (it too has the time and i don't want the time.)

 

[cyberpac9]

it is too early...ok, i used the form load property and set the default values using VBA...please ignore this post...