ContributionsMost RecentMost LikesSolutionsRe: Enforce unique values in field and also allow blanks / empty / null values.Yes you could, I have always created a formula field to accomplish this as I tend to use this field in other areas of my applications and as a formula field it can not be changed unless you edit the original field. It is useful at times for example in one of my applications I have a case ID that HAS to be unique and I don't want anyone to be able to change this from a grid edit view so I display my formula field in my reports and the only one who could change the original Case ID is a Role with Admin or Manager permissions that can open the original record to edit it. I was assuming the original post was looking to do the same...Re: Enforce unique values in field and also allow blanks / empty / null values.The only value able to be placed in a unique field more than once is a null value. You will need to make a second field that is a formula field and use an If statement to make this work. Your actual unique field will be the formula field. Something like as follows. Field one-[VIP's] Field two-Formula Field-If([VIP's]=null,null,[VIP's]) At this point your VIP's will copy over to your formula field if it is not null and you cant have duplicates but a null value in the formula field will still be allowed.