In the MS Access Form, I need to use and convert a decimal degree in one field to populate a second field showing degrees/minutes/seconds (DMS)
For example I need the following:
I enter in Field LATITUDE = 46.12365, I need Field LATITUDE DMS to populate with 46° 07’ 25.14”
I enter in Field LONGITUDE = -85.12365, I need Field LONGITUDE DMS to populate with 86° 52’ 34.86”
The DMS fields can be either 1 field showing the DMS or a series of 3 fields showing the D, the M and the S….doesn’t matter
I am using MS Access 2013
From the form design view, where do I paste the code? And then?