In Access 2010, there is a column in the database table that is called "ID." Instead of having just numbers, I want it to start with R1 then goes on to R2, R3, R4 and so on so forth for each new entry. How can I do that?
For some reason, when I paste * ="R" & IDFieldName * in the control source on the form, it gives me an error message on the form outside of design view. The actual unique ID is on the form and the unique ID is in a column name "ID" in the database if that helps. Thanks for your help.