Form not displaying Date Picker

[khughes46]

I removed the data mask from the table used in this form; the table and the query show the date picker; the form still shows the mask. Is there a way to update the form so the mask is gone and the date picker shows, short of deleting the date fields from the form and replacing them with the new definitions? I have done a compact and repair. Don't know what else to do. I thought that the table properties would propagate to the queries, forms, and reports. Thanks again for the help.

[RuralGuy]

Have you tried removing the Record Source of the Form and then putting it back yet?

[khughes46]

Just now and all my fields came up with #Name? Good thought though.

[khughes46]

I have redone my form and all the date fields now show the date picker. If there is a way to update forms and reports after changing properties in a table I would sure like to know. Thanks.

[RuralGuy]

When you remove the Record Source from the form I would expect each of the bound controls to now display #Name . Once you put back the Record Source I would expect the bound controls to behave normally. You are saying that is not what happened in your case?

[khughes46]

You are correct. I thought the same thing.

[RuralGuy]

There is no "Refresh the Record Source" for the form so if you added another field to the underlying table (for example), the process described is the only way to get the form to see the new field. Access keeps a separate "query" for the form Record Source and "refreshing" it is a pain but sometimes necessary. Obviously passing some of the more esoteric properties of the fields is not part of the "refresh" process.

[ipisors]

I thought that the table properties would propagate to the queries, forms, and reports

Generally, they do - but many other properties at the Form level can affect / override that.

Try setting the form Control's Format to Date, and be sure that show datepicker for dates is turned on in Properties for that control.
At that point, if the field really is date at the table level, and assuming you don't have a query underlying that control's Controlsource which is returning a field that really isn't a date or is an expression.......It will show the datepicker.

[khughes46]

That's interesting. I'll try that on my next form. Thanks.