Input Masks

[dkbrostyle]

Hi i don't know what to type in the input mask, what i want is for a time to be automatically entered in my table when new data has been entered.

I know the input mask for date is =date()
But i tried that with time but it not work.

Thank you very much for your time and help.

 

[Dugantrain]

To capture the time as well as the date, the syntax is "=Now()", but what you're missing is an Event Procedure to fire it off. If you set this as the Default value for the text box, I believe that'll work.

 

[dkbrostyle]

I tried the input masks, or sorry the Devault value and it not only displays the time it display the date as well. I how do i only get the time only please.

 

[bmacr]

In the properties window, with your textbox selected, under the Format tab, make the Format property Medium Time.