I am working with an existing database and have a table with a field called "Year". However, the data in it is not in date format, it's just text.
The year data is entered in the format of "1997/98" and "1998/99" and so on.
Is there a way of changing the data type to Date/Time and being able to specify a custom date format? I can't be losing the data and some people here are entering actual text into this field by accident (I know don't get me started!)
That works for tabbing but the problem is when the user clicks into the field using the mouse - any ideas?
PS - I know it's a matter of the user just pressing the Home key but they really are being pedantic about this...
Tell them they'll need to recode the entire db in order to eliminate their issue. The recode will need to be in a different language all-together, and you will need a good 6 months to learn that language. The field issue should be fixed sometime next year. In the mean time, deal with it.