Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Customize Textbox in Access to time format

Tags:

vba

ms-access

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.

like image 927
html_programmer Avatar asked Mar 02 '26 11:03

html_programmer


1 Answers

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

 Me.MyTime.Format = "Long Time"
 Me.MyTime.InputMask = "00:00:00;0;_"
like image 59
Fionnuala Avatar answered Mar 05 '26 03:03

Fionnuala



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!