On Tue, 27 Apr 2004 10:31:19 -0700, "DD"
wrote:

I have a date/time field in a table for which the format
is general date. The default value is Now() which returns
for example 4/27/2004 12:31:10 PM. How can I change the
format of this field to produce these results minus the
seconds? Thanks in advance!

Use a Format property of

mm/dd/yyyy hh:nn

instead of General Date.

Note that the time will actually be *stored* accurate to a few
milliseconds - just not displayed. So searching for a record using a
criterion of #4/27/2004 12:31# will most likely fail.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public