I have a table called "Seminar Dates" which has a seminar ID as the primary key and then a column with the seminar date and another column with the time.

I have another table with people who are coming/have come to the seminars.  I have created a basic look up drop down box that displays the dates of the seminar.

However, once I select the date from the drop down box it turns into that short date format (dd/mm/yyyy) instead of the long date format (day, dd, month, yyyy) which is used in the "Seminar Dates" table.

I want the dates to display in the long format in the 'People' table once I have chosen it from the drop down box.

I can't use an input mask because the lookup wizard requires that the box be a 'Number' - not a 'Date/Time'.

Does anyone know how to beat this?