Date Time expanding

[me1258]

I have a 2 combo boxes that display the date and time respectively.
They default to the current date and time.
After a record is entered if I go back and single click in these boxes I get the full time…not the short date as selected. I have short date selected in the form, the DB, and I have formatting on for short date for each of them.
Not matter what I do It will end up to be 3/13/2004 3:54:08 PM rather then 3/13/2004

Thanks.

 

[spacepro]

Why would you be using a combo to display the date and time?

And are you using the Date() and Time() functions as the default values?

Andy

 

[me1258]

Oops

Oops Sorry my bad...you are correct it is a txt box.
I use a txt box because at times the user will be entering data from a printed form and they need to have the date and time on the form.

Thanks

 

[me1258]

Main form

In the form I right click on the txt box and choose properties then default value and have =time() and = date () respectively.

It still will come up with date and time for both if you single click in the txt box.

 

[spacepro]

Ok,

In the underlying table set the default values and the formats at table level

Date Field > Format is Short Date , Default Value is Date()
Time Field> Format is Short Time, Default Value is Time()

Do the same on the form.

When you click on the txtbox the date will just show and when you click on the time field the seconds will appear only.

Hope this helps

Andy