Displaying Time Only

[Corinne]

I want to display a suggested time for when an event may have taken place. I thought I could use a date/time field with an input mask of 00:00 and it would capture only those four characters (hh:nn). I created a macro and the .txt file related to my query shows a date of 12/30/1899 followed by the inputted time of 12:15. How do I get rid of the inaccurate and undesired date and show just the 12:15?

[thhui]

Use Self-Defined Function

Function HrMin(time1)
    HrMin = Format(time1, "hh:mm")
End Function

[Corinne]

Forgive me - but where do I put that code? and the time1 portion - do I change that to my designated field name?

[marianne]

you can put that function in an module or simply on your forms module. Time1 is a variable from your field name in your form or you just hardcoded it inside your code as a variable.

[thhui]

Function is a very useful concept you must master.

Simple function example is :
sum([sales])
now()

You can use it freely in query, form, or report
eg. HrMin(now()) you get current time's hr and min.

[thhui]

By the way, pls be reminded that

the function code should be put into module in order to make it work for whole database.

time1 is just a parameter variable that could be changed by you.
You could put time1 as now() or whatever time you like.