I created a table and form for data, which includes a latitude and longitude field. Lat and Long date will be entered as degrees decimal. The lat/long data will be used for mapping purposes (exported to a GIS). For proper mapping, the longitude data must be negative. I don't want to rely on the user to remember to put a negative sign in front of their longitude data at the time of input. Is there a way that I can set up the field to automatically put a negative sign in front of the longitude value, if the user forgets to do it? Basically, I want to make sure that all data in the longitude field starts with a negative sign.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!