Is this just Access or What!!

[rewdee]

I have a report that I use Docmd.OutputTo method that exports an HTML file. The problem is that my boolean fields (checkboxes) do not appear. Nor does the field translate to true/false. Does anyone know a work around or a patch or code or anything to fix this problem.

Thanks,
Rewdee

 

[JamesMeadlock]

You could:

1) Remove the boolean fields from your query
2) Replace them with an expression like:
Bool1: Iff([yourbooleanfield],"True","False"

(You're just changing the datatype from Boolean to String)

 

[rewdee]

Thanks JamesMeadlock,

I changed the report rather than query. So in the report I deleted the checkbox fields and replaced them with textboxes. In the property sheet in the textbox control I did the similiar statement:

=IIF([MyBooleanField]=true,"TRUE","FALSE&quot

I regret though that it is less visually appealing than the checkbox.

Thanks again,
Rewdee

 

[JoeMiller]

I often use X for true and blank for false when I've got something I'm going to export. Takes up the same amount of space as a checkbox and gets the point across.

=IIf([MyBooleanField]=True,"X","&quot
Joe Miller
joe.miller@flotech.net

 

[rewdee]

I Like It!!!

Thanks,
Rewdee