DATE VALIDATION IN TEXTBOX

[DeanP]

I cannot find any code examples or references that I can use to ensure that a year value users input into a text box is:

(a) in the correct format "YYYY" and
(b) not greater than the current year.

Any advice would be appreciated.

[Rob342]

example:Me.TxtDDRYR.Text = Format(Now, "YYYY")
best to put in after update, this will check it straight away
Rob

[DeanP]

Thanks Rob!