You are viewing limited content. For full access, please sign in.

Question

Question

Show Date, not Datetime in form that is looking up data from SQL

asked on November 8

Hello, 

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?

Thanks! 

0 0

Replies

replied on November 8

In some cases I have created views of my SQL tables and Cast(TheDate as Date) to remove the time.

replied on November 8

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.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.