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.
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.
example:Me.TxtDDRYR.Text = Format(Now, "YYYY")
best to put in after update, this will check it straight away
Rob
Thanks Rob!