IN THE SPOTLIGHT: MDE to MDB Conversion Service
(also supports: ACCDE to ACCDB, ADE to ADP, etc)
IN THE SPOTLIGHT: vbWatchdog
VBA error handling just got easier...
" vbWatchdog is off the chart. It solves a long standing problem of how to consolidate error handling into one global location and avoid repetitious code within applications. "
- Joe Anderson,
Microsoft Access MVP
Meet Shady, the vbWatchdog mascot watching over your VBA code →
(courtesy of Crystal Long, Microsoft Access MVP)
IN THE SPOTLIGHT: vbMAPI
An Outlook / MAPI code library for VBA, .NET and C# projects
Get emails out to your customers reliably, and without hassle, every single time.
Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.
Provided by Allen Browne, October 2004. Updated March 2008
Consider using a text box in place of a check box on reports. You can then display crosses or check marks, boxed or unboxed, any size, any color, with background colors, and even use conditional formatting.
The text box's Format property lets you specify a different format for negative values. Since, Access uses -1 for True, and 0 for False, the Format property lets you display any characters you want.
For this example, we use the check mark characters from the Wingdings font, since all Windows computers have this font installed.
Control Source: Name of your yes/no field here. Font Name: WingDings Width: 0.18 in
You can now increase the Font Size, set the Fore Color or Back Color, and so on.
Select the characters from this list:
Character Keypad number Description Alt+0254 Checked box Alt+0253 Crossed box Alt+0252 Check mark (unboxed) Alt+0251 Cross mark (unboxed) Alt+0168 Unchecked box
To leave the text box blank for unchecked, omit the first character in the Format property, i.e. nothing before the semi-colon.
You can find other characters with the Character Map applet that comes with all versions of Windows. There are many other uses for these symbols, e.g. as graphics on your command buttons.
|Home||Index of tips||Top|
This is a cached tutorial, reproduced with permission.
Have your say - comment on this article.
What did you think of 'Check boxes in reports'?
No comments yet.
Why not be the first to comment on this article?!
Have your say...