Date format problem

[fergler]

I have a dialog form with a date field, formatted as Short Date, that updates a listbox. I set it up so that when the form opens, the date field is populated with the current date, which can then be changed if needed by the user.

The code is on the OnOpen Event and is:
Me!startdate = Now()

The problem is, when the current date autopopulates, it is formated with both the date and time. I would like to get rid of the time portion. I've searched the forum and can't seem to find any code to fix this. Am I doing something wrong? Can someone please help me?

Thank you in advance.

 

[Brianwarnock]

use Date() not Now()

Brian

 

[fergler]

Works perfect.

Thanks!

 

[CEH]

You also really don't need the code..... Just put Date() on the default value.