Date format in Access 2010 with SQL Server back end

[speedball]

Hello

I have a form in Access 2010 with a textbox that displays a date. The format is set to 'Medium Date', but the date displays as 'YYYY-MM-DD'.

I suspect it is an issue related to the backend, which is in SQL Server. I have a SQL Server stored procedure that populates a recordset in Access, and I then use that recordset as the source for the form.

All the information on the form is correct, I just want to change the format of the dates.

The data type in SQL Server is set to 'date'.

Any suggestions much appreciated.

Thanks
Speedball