DakotaRidge
New member
- Local time
- Yesterday, 17:09
- Joined
- Jul 21, 2025
- Messages
- 14
I have a form in one of my databases that has a map of the USA. The map shows the states where foods have been recalled by the federal government or the producer.
I would like to know the most efficient way to physically move the state labels and checkboxes from the upper left corner of the form to their normal positions on the map. I tried the .Move function, but that method requires entering 200 four-digit values into VBA. That's not a real problem unless I need to move the map in the future. That could be necessary if I add more attributes to the form. The table has 80 fields now. The fields store data such as the number of deaths and hospitalizations due to contaminated or mislabeled food products.
I can also hide and unhide the labels and checkboxes. But what is the most efficient way to do this?
Thanks.
I would like to know the most efficient way to physically move the state labels and checkboxes from the upper left corner of the form to their normal positions on the map. I tried the .Move function, but that method requires entering 200 four-digit values into VBA. That's not a real problem unless I need to move the map in the future. That could be necessary if I add more attributes to the form. The table has 80 fields now. The fields store data such as the number of deaths and hospitalizations due to contaminated or mislabeled food products.
I can also hide and unhide the labels and checkboxes. But what is the most efficient way to do this?
Thanks.