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.