Input Mask and Maths for Degrees Minutes Seconds

[Stevie]

I am trying to create a field to store Direction in Degrees Minutes Seconds.

I will also need to do maths with it. i.e. Criteria >= 03°15'00" .
I want to subtract a Surveyed AsBuilt Direction (BEARING) from the Designed BEARING then if it is more than the Criteria allowed, the difference in value should show up in the new (ERROR) field.
I have managed to make the other fields work. They are just normal numbers. Result shown below.
Any advice will be greatly appreciated. I will also need to limit degrees to < 180, minutes & seconds to <60.

[Welshgasman]

Any reason why you can not use separate controls?

[Stevie]

Controls? Sorry I am a newby. Diving in the deep end perhaps.

[June7]

Converting DMS to decimal degrees (and the reverse) is a common topic. Numerous code snippets on the web. Could probably search this forum and find several.

Controls are objects like command buttons, textboxes, comboboxes, labels, etc. - things you put on forms and reports.

Could use separate textboxes for input of D M S by user. If those textboxes are bound to fields then D M S are saved to table. If input is to UNBOUND textboxes, then use code to convert to DD for saving to record.

Textboxes have Validation Rule property you can set for limits on user input.

[Welshgasman]

Controls? Sorry I am a newby. Diving in the deep end perhaps.

I was thinking of three separate textboxes, one for each element in the input.

Admittedly just a little more to input, but a tab key is easy to use?
Then each portion ccould be validated.
Another option might be to enter with known delimiter like :, so 98:23:32, then split that to get the relevant elements and validate?