Can I turn off the date picker?

[tmac]

I am using Access 2007 to edit a table in a SQL 2000 database that
resides on our remote web host. It's quite a large table, with about
3,250 records, some of which have VERY substantial memo fields.

In Access 2003 and earlier versions, I never had problems, but Access
2007 hangs whenever I try to edit the date field in any record, and
the only thing I can put my finger on as a possible problem is the new
built-in date picker. I can navigate and edit ANY other field, but
not the date field.

Since I can't edit the design of this table because it's remotely
hosted, is there some way in the program's general preferences to turn
off the date picker completely? It's really not something I need, and
I really need to see if that's causing my problem.

Thanks,

tmac

 

[Guest]

Are you able to change the design of the form?

If so, replace the DatePicker control with a textbox or another solution.

Steve

 

[RoyVidar]

I am using Access 2007 to edit a table in a SQL 2000 database that
resides on our remote web host. It's quite a large table, with about
3,250 records, some of which have VERY substantial memo fields.

In Access 2003 and earlier versions, I never had problems, but Access
2007 hangs whenever I try to edit the date field in any record, and
the only thing I can put my finger on as a possible problem is the new
built-in date picker. I can navigate and edit ANY other field, but
not the date field.

Since I can't edit the design of this table because it's remotely
hosted, is there some way in the program's general preferences to turn
off the date picker completely? It's really not something I need, and
I really need to see if that's causing my problem.

Thanks,

tmac

If you view the properties of the form control, there's a property
called "Show Date Picker" rather close to the top of the Format tab.

If you change that to "Never", it shouldn't display. Whether or not
that cures your problem, would be interesting to know.

I haven't found a setting for it in the Access Options, though.