For this you got to edit the properties of Datagrid Control and you don't have to use FORMAT() in your select statement. Anyways Short date in Access contains only the date part and doesn't include the time part in it.
querr = "SELECT Format(Dateofjoin,'dd-mm-yyyy') from UserData "
but it gave an error.
What was the error? Did you try that query directly on your ACCESS DB?
- Vijay G
Strive for Perfection