Address fields allow invalid State names
Is there a way to force the State name to be valid. I have an office address field but the user can enter anything in the State name, it doesn't have to be valid, so we have a lot of records with inv...
Forum Discussion
If you look at the field properties for that address field it will give you the subfield names that you should be able to use in formulas
It will tell you what the field name is for the state field
It will tell you what the field name is for the state field
- i was thinking of that and I was going to make a formula checkbox field. My thought is how would I reference a field in another table that is not connected. So if [Office Address State] is one of [State Table: State], yes, no.
Is that possible?
