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

Forms
Updated November 8, 2019
asked on November 8, 2019

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, 2019

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

replied on November 8, 2019

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.

Details
Related Posts
Loading ...