These are old databases and were not build with any type of control on
date fields.
but some of them show a calendar control beside them and some do not.
does anyone know why?
Is there a way to make it show the calendar?
I wish it would not show but once they saw it on one they now want it
on others.

On Mon, 25 Jul 2011 08:26:00 -0500, sparks wrote:

There's a text box property called "Show Date Picker", check this and
also check that the underlying field type is DateTime if the property is
set to "For Dates"

--
Travis Crow

"sparks" wrote in message
news:cjrq27tb6nni01i49rpvsbvghgfbmj4svk (AT) 4ax (DOT) com...


If you do NOT set the format of the control to date, then the date picker
does not show.

So, setting the format of the text box on the form to short date, or
whatever you typically use.

If even for un-bound controls, if you set the format to date, then you get
the date picker.

There is also a setting on the "format" tab of the properties sheet - it is
called

Show date picker: (two choices are "For Dates" or "Never").

So, you can check the above setting, but I not sure it actually exists in
2003, but I am able to see/set this when opening a 2003 database with 2010,
so check this also.

Quite sure, your issue is first one above - with format of date, you see
date picker.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com
,

Thanks everyone got me looking and trying something in the right area.
It turned out they had an input mask and it will not work with it.



On Mon, 25 Jul 2011 08:26:00 -0500, sparks <sparks (AT) home (DOT) com> wrote:

Hi Sparks

In the property settings of the date fields, check each one to see what the
setting is:

ShowDatePicker, there are two options.

a. Never
b. For Dates

HTH
Mick