Prev: Unable to use filter in datasheet view or add criteria to query in design view
Next: Select to reference an other record or row
From: John W. Vinson on 8 Mar 2010 13:26
On Mon, 8 Mar 2010 09:36:01 -0800, Iram <Iram(a)discussions.microsoft.com>
wrote:

>John, some how the -1's and 0's started to appear in the reports, all is good!
>

You can set the Format property of the textbox to

"";"Yes";"No";""
"";"True";"False";""

if you want the -1 to display as Yes/True, 0 as No/False. This rather obscure
four-value format applies four different formats to numeric fields that are
positive, negative, zero and NULL respectively. Since a yes/no field is either
0 or -1, the other options aren't needed.
--

John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2 3
Prev: Unable to use filter in datasheet view or add criteria to query in design view
Next: Select to reference an other record or row