That sounds about right. You can have the textbox as unbound, so it will accept any data type. I would use the after update event to go back and check the value, if the value is in lat/longitude format, leave it, if it is in degrees, make a conversion function to convert it to lat/long format, and if it's not in degrees or lat/long format, msgbox the error then return focus to that field.

You would also probably want to add the same...

I've tried searching on Google and for other questions similar to mine, but all I get are results on how to use the LostFocus event or Deactivate, etc., but I'm under the impression each of these applies to controls on a form, or the actual form itself. What I need is a way to determine when my access database looses the focus entirely to another program in Windows, such as if I click on one of my access forms, MSAccess will have the focus. If I...