How to format a textbox to have a year within its string.

[c0crut01]

I know you can create a textbox that automatically shows the date and time. However, my boss wants to be able to have the current year within the Permit Number. Attached is a picture of what he wants. Each Permit Number starts with the static letters "EP" followed by the current year (in this case 2019) followed by the auto generated permit number. I need a way to format this in the property sheet so that when 2020 comes along, the 2019 will automatically change to 2020.

Any help is appreciated.

[June7]

Generating custom unique identifier is a common topic. Start with https://www.accessforums.net/showthread.php?t=23329

[orange]

Further to June's advice, there is a difference between data storage and data presentation.

Data should be "atomic". That means that data should be stored in its most basic, indivisible
form; for example, avoid storing a name as a single data element, with first name,
middle name, Lastname. Each of these are separate pieces of data and should be stored in separate columns.

For presentation, you can concatenate values to customize the display eg. John G. Smith.
Or as in your example Pmt-2019-0221-X or whatever you want to present.

[ArviLaanemets]

I found an older thread with similar question (https://www.accessforums.net/showthread.php?t=65653). When you really want to go with custom ID, I posted there an answer, where I described the calculation of ID in format CCYYYYMMDDnnn I use in one of my databases.