表单中的短日期问题 [英] 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

展开 | 选择 | Wrap | 行号

谢谢我没有意识到你可以直接输入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屋！