Data Input Mask and Expiry Message

[JPRENG]

I want to have an input mask on an 'Expiry Data' Field so that the input method is 'MON-YY" and I need access to realise it as a data. And then I also need when a user opens a record an anything that is 2 weeks from expiring I need an error message to pop up. Any ideas?

 

[PaulO]

1) I would simply store the full date in a DATE/TIME field, this way Access will always know the value is a date.
2) In the form that gets loaded, I would perhaps write some conditional formatting (e.g. red background) into each record's [expiry date] field based on a calculation whether the expiry date is within 14 days of the current date
i.e. = [Expiry Date] - Date() < 15