Formating textbox control to display ONLY date NOT time

[curium]

Hi

I'm fairly new to access so go easy on me if this has an obvious answer.

I have a form used to submit data to a table.

One of the fields in the table has data type Date/Time

I'm only interested in the date.

The form uses a textbox control to enable the user to input a date with the format dd/mm/yy.

The problem is, when you click in the textbox control it shows the Date along with the time.

The time is not required, I don't want to record that information and it annoys me from an aesthetics POV.

How can I change this so that only the Date is displayed and only the Date is recorded in the table field?

Many thanks.

 

[pono1]

This works for me in Access 2007...

• Open the form with the control that you want to display just the date in design view.
• Click the textbox with the date.
• Press F4 to display the Properties window (if it isn't aleady open)
• On the Properties window's All tab, look for a property called Format
• Set the Format value to Short Date.

Regards,
Tim