Win7 64bit, Access 2010 32bit
Expression Builder problem with setting Control Source in a report field to
=IIf([TAXABLE],"T","F") => all values are "T"
or with
=IIf([TAXABLE]=-1,"T","F") => all values are #Type!
Both formulas work ok in creating a field in an access query
TAX: IIf([TAXABLE],"T","F")
TAX: IIf([TAXABLE]=-1,"T","F")
The table is a linked MySQL table with the MySQL TAXABLE field type as TinyInt(1) [-1 = True, 0 = False].