Access 2013的时间/日期字段的输入掩码不起作用! [英] Input Mask for Time/Date field of Access 2013 does not work!
问题描述
这些是我用于字段的输入掩码的设置,该字段应该是时间字段,而不是日期字段:
These are the setting I used for the input mask for a field that should be a time field, not a date field:
00:00; 0; _
00:00;0;_
但是,使用我创建的表单,字段旁边有一个日期按钮,当我选择或输入短时间输入掩码的日期时,表单仍会接受输入。这对我想要创建的数据库完全具有破坏性,因为
它将允许很大的人为错误。
However, with the form I created, there is a date button beside the field, and when I do select or type a date with an input mask of short time, the form will still accept the input. This is completely disruptive on the database I want to create because it will allow a large possibility of human error.
当访问接受所谓的时间字段中的日期时,时间将被标记为0:00!如果我们然后使用这些数据来获取生产指标,那么它将会搞砸所有内容。如何限制访问2013只接受某个字段中的时间,而不是日期
,因为这本身就是一个单独的字段。
When access accepts the date in a supposedly time field, the time would be noted as 0:00! If we then use this data to get production metrics, it will screw everything up. How do I limit access 2013 to just accept time in a certain field, and not the date because that is a separate field in itself.
推荐答案
您好,也许您可以尝试使用未绑定的文本框输入时间并使用其AfterUpdate事件在字段中指定时间。
Hi, Perhaps you could try using an unbound textbox to input the time and use its AfterUpdate event to assign the time in the field.
这篇关于Access 2013的时间/日期字段的输入掩码不起作用!的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!