Hiding a control (but not really)
Posted on 2006-06-16
I have a control (combo box) that needs to be "hidden". However, several functions SetFocus on the control (I also need it for calculating an IndexCount).
When I actually changed "Visible" = No... the Access form caused several errors.
I tried to just "lay" another control (e.g. box and unbound textbox) on top of the combo. Then (for testing purposes) I changed box/textbox's background color to yellow. Later on I would change it to the actual form background color (light gray)...
Unfortunately, that idea (to hide the combo behind a box) doesn't work... although I see the yellow box... the combo is still visible/active inside the yellow background shape.
I also set the combo's width to something like 0.001... now it appears like a "vertical" bar... but it's still obvious to see.
Any ideas how to make the combo "invisible" WITHOUT setting its Visible property to No?