This example shows the two different places to use booltext - display and filter.
| dbBoolText |
This property offers a method of replacing the “True,False” standard Boolean text displayed in a Boolean type of cell with any user defined text or HTML tags.
| Property Syntax |
Obj.dbBoolText="Display_true_replacement_text, Display_false_replacement_text, Drop_True_replacement_text, Drop_false_replacement_text"
| Parameters |
|
Parameters |
Description |
| Display_True_replacement_text | Text displaced when value if cell is True in display of Grid and Form. OK to use image |
| Display_False_replacement_text | Text displaced when value if cell is False in display of Grid and Form. OK to use image |
| Drop_True_replacement_text | Text displaced when value if cell is True in Filter and Edit drop boxes. MUST be text and defaults to "True". |
| Drop_False_replacement_text | Text displaced when value if cell is False in Filter and Edit drop boxes. MUST be text and defaults to "False". |
| Example |
|
<% Set X = Server.CreateObject("ASP.DB") X.dbMode="grid" X.dbQuickProps="1;NWIND;;grid;4,auto" X.dbSQL="SELECT ProductName, Discontinued From Products" X.dbBooltext="<IMG SRC=htmldoc/happyface.gif>,<IMG SRC=htmldoc/sadface.gif>,Ya,Na" X.ASPDB %> |
| Output |
|
This example shows the two different places to use booltext - display and filter. |