RESTRICTING ACCEPTABLE DATA - Jun 7th, 2015

Now it’s time to modify the parameters of the “State” field, so click on modify next to the “State” field entry. If the input validation fields are not showing, click on “show all”. The Required box should already be checked. State/Possession abbreviations all have 2 letters so enter a 2 in the “Min” and the “Max” length boxes. State/Possession abbreviations are always capital letters, so select “only allow characters” from the “Allowed Content” menu and type all the capital letters A through Z (no commas and no spaces) in the box to the right. Don’t include a “B” or a “Q” since they do not appear in any of the official abbreviations. In the “Field Description” Box type “Enter only official 2 capital letter abbreviations”. Then click “Save” to save your changes to this field. !!!YOU MUST ALSO CLICK ON THE “SAVE DETAIL” BOX OR YOUR CHANGES WILL NOT BE SAVED TO YOUR DATABASE!!!

Terms of Service