display calendar for date fields in form

[sam]

How can I display a calendar icon for date fields in access form?

Thanks in Advance

 

[John W. Vinson]

How can I display a calendar icon for date fields in access form?

Thanks in Advance

Depends on your version of Access. A2007 has a calendar control built in;
you'll need a third party tool for earlier versions. Also, what do you mean by
a calendar "icon"?

 

[sam]

Hi John, Thanks for your help.
I have Access 2007. I have few fields in forms such as Date In, Date Out,
Date Close etc. For some reason I am getting a Calendar icon for Date In
field (A small calendar icon besides Date In Text field where I can click on
the icon and it displays a calendar from which I can select a date). But for
others I dont see this icon.

I hope I made it clear.

Thanks in Advance

 

[niuginikiwi]

Hi Sam,

In design view, go to the property sheet of the individual text fields
(txtDateIn, txtDateOut, txtDateClose) and on the Format tab of the property
sheet on the fourth row there is a property called "Show Date Picker" .. set
that to "For Dates" on the right hand column instead of "Never" and the
calendar icon will show up once you click on the control in the runtime mode.

 

[sam]

Thanks for the help,

The problem is it is already showing a calendar icon for certain text boxes,
But not for some. How do I make a text box of a Type 'Date' ? I think some
text boxes are not behaving as a Date type.

Thanks in Advance.

 

[sam]

Thanks for the help,

The problem is, it is already showing a calendar icon for certain text
boxes, But not for some. How do I make a text box of a Type 'Date' ? I think
some text boxes are not behaving as a Date type.

Thanks in Advance.

 

[John W. Vinson]

Thanks for the help,

The problem is, it is already showing a calendar icon for certain text
boxes, But not for some. How do I make a text box of a Type 'Date' ? I think
some text boxes are not behaving as a Date type.

A textbox is NOT a field and is NOT a place to store data.

It's just a tool, a window.

Data is stored in a field in the Table, and *only* there.

Try opening the Table (not the form) in design view; select this field; and
look at its datatype in the second column of the design grid. If you're
storing date information it should be Date/Time.

 

[niuginikiwi]

If your text boxes are unbound then you can go to the properties of the text
boxes and change their format to date types eg Long Date, Medium Date, Short
Date etc.

If text box is bound, you should check the data type in your table design
for those date fields you are referring to.

 

[rvp15m]

Thanks for the help,

The problem is it is already showing a calendar icon for certain text boxes,
But not for some. How do I make a text box of a Type 'Date' ? I think some
text boxes are not behaving as a Date type.

Thanks in Advance.

I also had this problem and googled to find the result. Your post
helped me (at least for one of my date fields).

This is what I did:
Ensure the field data type is set to Date/Time in the table
properties, and the format is set to "ShortDate" (it may work for
others, but I am recounting what I did)
Select "For dates" for the "Show Date Picker"
In the data tab for the field DELETE *any* input mask. I had an input
mask of "0000-00-00;0;_". After I deleted it the calendar icon was
coming up when I select the field on my form. I think there are two
places where input masks may be hiding, in the table's
FieldProperties> General, and also in the form.. when you right click
the box (in Design view) and select Properties>Data>"Input Mask"

Hope it works for you!!!