VBAhole22
Registered User.
- Local time
- Today, 17:05
- Joined
- Jan 18, 2002
- Messages
- 117
Don't you just hate those pesky little quirks about Access that seem to get under the skin?
I have a few, maybe some folks can add others or suggest solutions. Here goes:
Setting up form controls has to be the biggest pain ever. Let's say you have 5 text boxes with labels all lined up on on top of the other. You have aligned left, spaced evenly and they look great. Now you decide you need a bigger font so you change it and size to fit for all. Well now your labels are over hanging into the control. Can you move all five labels over to the left without moving the controls along? I don't think so.
Here's another one. You have a jumbled set of text boxes and their labels. You want to line them up on the same row. You select them all and hit align bottom. Whammo! they go all out of whack, some go up, some go down! Is there some ordered way to figure out which box is going to move to match the other boxes?
Here's yet another. You make a control on a form and you add some VBA code to a few events. Later you realize that you didn't follow the naming convention for the control so you change the name of the control and you change the name of the event code in the VBA editor and you are good to go right? I don't think so. Access doesn't recognize the changes until you go into the newly-named control and go to the properties sheet and events and reclick that you want an event and then it points right back to the code you renamed!
I think I could come up with more, but I don't want to have all the fun.
I have a few, maybe some folks can add others or suggest solutions. Here goes:
Setting up form controls has to be the biggest pain ever. Let's say you have 5 text boxes with labels all lined up on on top of the other. You have aligned left, spaced evenly and they look great. Now you decide you need a bigger font so you change it and size to fit for all. Well now your labels are over hanging into the control. Can you move all five labels over to the left without moving the controls along? I don't think so.
Here's another one. You have a jumbled set of text boxes and their labels. You want to line them up on the same row. You select them all and hit align bottom. Whammo! they go all out of whack, some go up, some go down! Is there some ordered way to figure out which box is going to move to match the other boxes?
Here's yet another. You make a control on a form and you add some VBA code to a few events. Later you realize that you didn't follow the naming convention for the control so you change the name of the control and you change the name of the event code in the VBA editor and you are good to go right? I don't think so. Access doesn't recognize the changes until you go into the newly-named control and go to the properties sheet and events and reclick that you want an event and then it points right back to the code you renamed!
I think I could come up with more, but I don't want to have all the fun.
