Today’s guest blogger is Michael Groh,
Office 2007, co-author of the popular Access 2007 Bible. I often use hidden controls on Access forms and reports to hold intermediate values,
Microsoft Office Pro Plus, temporary "flag" values, and the like. Because these controls are invisible at runtime,
Office 2007 Pro, it's useful to set their colors to garish combinations (like red fore color over a yellow back color) so that,
Microsoft Office Pro Plus 2010, in design view, it's immediately apparent they're not meant to be viewed by users. I also use hidden controls as a way of leaving 'comments' about the form or report's design. Because invisible controls are only seen by myself and other developers in design view,
Office Professional, a hidden label describing the purpose of a particular control or explaining some unexpected design issue (such as a calculated control) to make it easier for the next person to figure out my logic. Have an Access Power Tip that you want to share? Send it to Mike and Chris at accpower@microsoft.com. <div