CODEWITHSUNDEEP
ms-accessvba
Trace
Trace

Reputation: 18859

Customize Textbox in Access to time format

Is there a way (if needed, programatically) to precustomize a Textbox in Access so that a user can input "time" in a format like 18:00:00, but while the colons are already available and can not be "overwritten" by the user?
I mean this in the sense that a user would not need to type the colons; they would standard be available in the textbox.

Upvotes: 3

Views: 2354

Answers (1)

Fionnuala
Fionnuala

Reputation: 91316

You can set the format to time and use an Input mask.

 Me.MyTime.Format = "Long Time"
 Me.MyTime.InputMask = "00:00:00;0;_"

Upvotes: 5

Related Questions