Date/Time Input Mask

[Triscuit]

I have a Date/Time text box on a form that goes back to a Date/Time field in a Table.

I want this text Box to only display a Long time format, and it works until I click into the text box and it changes to a Full Date/Time format.

I have the Format and Input Mask set to Long Time in both the form and the Table.

Any suggestions would be appreciated.

 

[Steve R.]

I have the Format and Input Mask set to Long Time in both the form and the Table.

You used the word "form", I assume that you meant the control (textbox) where you enter the date or time. Check the textbox format property an verify that it is set to what you want. If you did this on the "form", it wont work; it has to be the control.

Also are you really after "Long Time"? Long time is: "5:34:23 PM".
Look up "Format Property - Date/Time Data Type" in access help.

 

[Triscuit]

I guess it was just acting a bit wonky. Closed and opened it a few times and it worked. Thanks for the reply Steve.