Can I make a calculated text field unique?

[alexandervj]

I have a few string fields and a calculated field which just concatenates the string fields. I want the calculated field to be unique and not allow creation if the combination of string fields already exists in the database. How can I do this? Thanks

[JoeM]

I don't think so, unless you are storing the calculated field in a field which is set to be unique.

[alexandervj]

I am storing the calculated field in a field but not sure how to set it to be unique. How would I do this? Thanks

[JoeM]

Open up the table is Design View, go to the Properties of that Field, and set the Indexed property to "Yes (No Duplicates)".

Are you doing the calculation in a query and writing it back to a table?
Or are you using the new feature in the newer versions of Access that allows you to store Calculations in a Table?

If the latter of those two options, I don't know what the properties of those fields look like, if they are different. I am still on Access 2007.