Entered Date storing as Time

[tgwacker]

I have a form with a date field being entered to insert a new row into a table. Prior to inserting the data to the table, I stopped the execution on the INSERT statement and looked at the field being inserted. It has the valid date that I entered. After doing the insert, the field in the table contains a time. The table field has the following definitions:
Data Type: Data/Time
Format: Short Date
Input Mask: 00/00/0000
Show Date Picker: For Dates

The field in the form has the following Properties:
Format: Short Date
Show Date Picker: For Dates
Input Mask: 99/99/9999;0;_

Also, when I place the cursor on the date field on the form, the Date Picker does not appear.

[June7]

The Date Picker will not trigger when an Input Mask is set.

Show the INSERT statement. Probably need # delimiters. "INSERT INTO tablename(fieldname) VALUES(#" & Me.controlname & "#)"

Why code to create record? Why not bound form?

[tgwacker]

Thank you.

I removed the Input Mask and the Date Picker showed. I added the # sign to the INSERT and the date was added to the table instead of being added as a time.