Backstory: I'm building an Access DB at the moment refreshing myself on everything. I have 30 employees to go in the DB. Most employees will have the same data. However, some employees will have numbers going into a set field that will be eventually calculated. However, on the entry form I would like to be able to change the name of the individual Labels of the fields. For example, Adam will have a number entered for Registration in Indiana. However, Becky will have numbers being entered but the data will be for Counsel Expenses. So, one number field but two different labels depending on the employee. I would prefer to not use a drop-down but enter the information as I reach the form for both Adam and Becky.
Is it possible for me to create a form allowing me to change the label depending on the employee?