Hi, is it possible to display values in button captions? I would like to have a button that says [ProjectNumber] & ", " & [Project Name]. The database only works on one project at a time, so there's only one button for one project being displayed. I was wondering if it's possible to type a formula into the caption property, but as you would expect, it gets displayed as text. I'm hoping that I'm just typing it wrong, and that there's a way to do this, but I'm guessing the only way to do it is in VBA.
My current solution is to use a text box to serve this purpose, but I want it to change colors when my cursor hovers over it. I can't seem to make that work with the Mouse Move event, because there doesn't seem to be a way to get the color to change back. This is the reason I was trying to use a button, so I can set the Hover color, but then there's the issue of displaying the values in the caption.
If someone could please help me come up with a solution for either of these, I'd greatly appreciate it. Thanks!
My current solution is to use a text box to serve this purpose, but I want it to change colors when my cursor hovers over it. I can't seem to make that work with the Mouse Move event, because there doesn't seem to be a way to get the color to change back. This is the reason I was trying to use a button, so I can set the Hover color, but then there's the issue of displaying the values in the caption.
If someone could please help me come up with a solution for either of these, I'd greatly appreciate it. Thanks!