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