Date/Time formatting (1 Viewer)

[bayman]

For a Date/Time field, I want to display it as a Long Date with the Time. However, in table design, the only format that includes the date AND time (General Date) displays the date in the Short Date format.

How can I work around this?

Thanks in advance.

 

[bradcccs]

Let the table store the date/time as "general date" as this is all access needs (it actually stores the date as decimal representation of the date).

When you display your form, you can create you own custom format.

Select the text box that you wish to display the date etc, and view the properties. You can then enter your own format in the "format" property. Do Not select one of the default options.

Custom format example:

dddd", "d mmmm yyyy hh:nn:ss AM/PM

(I am assuming that you are obtaining the date/time by coding etc, as I would think your users would get tired of entering the full detail.)

HTH

Brad