表单中的短日期问题 [英] Short date problems in a Form
问题描述
嗨
我有一个访问表单,其中日期输入为短日期,输入掩码要求输入格式为mm / dd / yyyy。 Access会自动将此值更改为单个数字日期/月份到m / d / yyyy。有没有办法强制表格保持输入原始格式的日期:即:01而不是1。这些数据不会保存到表格中。
我看过但在任何地方都找不到。
谢谢
Ivan
Hi
I have an access form in which dates are entered as short dates with an input mask requiring the entry to be in the form of mm/dd/yyyy. Access automatically changes this for single digit dates/months to m/d/yyyy. Is there any way to force the form to keep the date in the original format entered: ie: "01" as opposed to "1". This data is not saved to a table.
I have looked but cannot find this anywhere.
Thank You
Ivan
推荐答案
嗨
我有访问表格其中日期作为短日期输入,输入掩码要求输入为mm / dd / yyyy。 Access会自动将此值更改为单个数字日期/月份到m / d / yyyy。有没有办法强制表格保持输入原始格式的日期:即:01而不是1。这些数据不会保存到表格中。
我看过但在任何地方都找不到。
谢谢
Ivan
Hi
I have an access form in which dates are entered as short dates with an input mask requiring the entry to be in the form of mm/dd/yyyy. Access automatically changes this for single digit dates/months to m/d/yyyy. Is there any way to force the form to keep the date in the original format entered: ie: "01" as opposed to "1". This data is not saved to a table.
I have looked but cannot find this anywhere.
Thank You
Ivan
你好Ivan,
再看看
Hi Ivan,
Look no further
谢谢我没有意识到你可以直接输入mm / dd / yyyy到表格的格式部分。
Ivan
Thanks I didn''t realize you could enter mm/dd/yyyy dirctly into the format section of the form.
Ivan
谢谢我没有意识到你可以直接输入mm / dd / yyyy到格式部分表格。
Ivan
Thanks I didn''t realize you could enter mm/dd/yyyy dirctly into the format section of the form.
Ivan
不是格式部分。打开表单的代码模块并粘贴代码。将Text0更改为适合您的文本框的名称。
现在你是一名真正的程序员:)
Not the format section. Open the code module for the form and paste the code. Change Text0 to the name of your text box to fit.
Now you are a real programmer :)
这篇关于表单中的短日期问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!