Changing date to date with time

[mulchgirl]

I currently have a report generating a date field that lists date only. I changed the format for the data type for the field in the table to General Date and tried changing the input mask for the field in the design view of the report to show the time, but it is still only printing the date. Any help would be great!

[June7]

It is printing only the date for the previously existing records? That is because the time is 0. Access doesn't show 0 time unless you use Format function.

Format(#1/1/2012#,"m/d/yyyy h:nn:ss AM/PM")

will use midnight as default time and show as
1/1/2012 12:00:00 AM

[mulchgirl]

I'm not the greatest at this, so....do where do I enter the above string - as the input mask under the General tab for the field in the table, or do I leave that blank and put the string somewhere else?

[June7]

This has nothing to do with input mask which controls how data is saved.

This has to do with how data is displayed.

Can try the Format property of textbox. The only choice that comes close is GeneralDate and it still doesn't seem to show time when it is 0.

Use the Format function in a query or unbound textbox ControlSource to force display of time parts even when time was not saved as part of the data. This is creating a field with an expression and that field is not editable.