Today’s guest blogger is Michael Groh,
Office Pro 2007, co-author of the popular Access 2007 Bible. I often use hidden controls on Access forms and reports to hold intermediate values, temporary "flag" values,
Windows 7 Starter, and the like. Because these controls are invisible at runtime,
Office Home And Stude/nt 2010, it's useful to set their colors to garish combinations (like red fore color over a yellow back color) so that,
Windows 7 Starter Key, in design view,
Office 2007 Key, 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, 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