Date/Time field not showing and recording the time.

[mavisyew]

Hi All,



I have created a tbl with a form to allow the user to enter information.
tblCasehistory.

In the table there is a field Resolved Date.
The data format is date/time.

When i add the field to my form for the user to enter the date, the time is not showing or recorded into the database.

The format for both the tbl and form is General Date.

[alansidman]

Is the control in your form bound to the field in your table?

[mavisyew]

Hi Alansidman,

The field is bound to the table field.

[pbaldy]

for the user to enter the date.

Is the user entering a time?

[mavisyew]

They will enter using the Date Picker.

[pbaldy]

If they don't enter a time, how would one get saved? You could have them enter the time separately and add them together in the background.

[mavisyew]

Hi Pbaldy,

You are right.
I am blur just now.

Thanks for reminding me

[pbaldy]

No problemo.