How to remove date picker from query fields

[AndrewAfresh2]

I have various tables with date fields and have recently set all of them to not show the date picker; but the date picker still shows in select queries using those tables (old queries and new queries). Is there a way I can remove it from the queries? The query property sheet doesn't seem to have a relevant option. Thanks guys

 

[stumac]

Unfortunately you cant. A couple of suggestions:

If you dont need to edit the date then create an expression: Mydate:[DateField]&""

If you do need to edit it then you could create a datasheet view form that will emulate a query when opened.

 

[Micron]

Sounds like you are working in queries, which is really no better than working in tables, which should be discouraged. The safer/better place to work on data is in forms.