Quick Search


Tibetan singing bowl music,sound healing, remove negative energy.

528hz solfreggio music -  Attract Wealth and Abundance, Manifest Money and Increase Luck



 
Your forum announcement here!

  Free Advertising Forums | Free Advertising Board | Post Free Ads Forum | Free Advertising Forums Directory | Best Free Advertising Methods | Advertising Forums > Other Methods of FREE Advertising > Guest Books Directory

Guest Books Directory Here is a great way to get some inbound links to your site, and message heard by people who also post and read these books. (Tip: Dont use your real email address on them)

Reply
 
Thread Tools Search this Thread Display Modes
Old 05-16-2011, 06:06 PM   #1
bolsooi31
 
Posts: n/a
Default Microsoft Office Enterprise 2007 Roll-your-own “t

Posted by Chris Downs, writer, Access IW Content Team Here’s a great tip suggested by Clint Covington. Using an expression and a Rich Text text box, you can create a traffic light indicator in an Access form or report, as in the following illustrations: First, add a text box to the form or report, and set the following properties: Property Setting Text Format Rich Text Locked True Enabled False Then, enter the following expression into the Control Source property: ="<font face=Webdings size=1 color=" & IIf([Status]="Active","#ED1C24", IIf([Status]="Resolved","#FFF20C", IIf([Status]="Closed","#22B14C"))) & ">n </font>" Edit the items in bold text so that they refer to field names and values in your database. This expression creates an HTML string that the Rich Text text box can interpret. In short, it specifies the letter “n”, which in the Webdings font corresponds to the circular icon. The IIf functions set the icon’s color to red, yellow, or green, respectively. You can nest more IIf statements together to accommodate more values—check out this color reference to obtain the Hex values of more varied colors. Note: Instead of entering the expression in the Control Source property of the text box, you can also create a calculated field in a query, and then bind the text box to that field. For example, in the Field row of the query design grid, enter: StatusLight: "<font face=Webdings size=1 color=" & IIf([Status]="Active","#ED1C24",Microsoft Office Enterprise 2007, IIf([Status]="Resolved","#FFF20C", IIf([Status]="Closed","#22B14C"))) & ">n </font>" And then bind the Rich Text text box to the StatusLight field. <div
  Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT. The time now is 08:48 PM.

 

Powered by vBulletin Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Free Advertising Forums | Free Advertising Message Boards | Post Free Ads Forum