I have a SQL table that is linked to an Access database. The date field is showing as a date/time field in SQL, therefor showing date/time in the form lookup. Is there a way to have the form only show the date for the lookup?
Show Date, not Datetime in form that is looking up data from SQL
In some cases I have created views of my SQL tables and Cast(TheDate as Date) to remove the time.
What type of field are you using on the Form? If it is a Single Line (plain text) then in is going to show everything, but if you add a Date field to the form and use that for the lookup it should only display the date portion. If you make it read only it shouldn't display the date picker.