yes/no checkboxes

[Pearl]

I have a report based on a query that has yes/no checkboxes. Is there a way
without using coding to allow me to translate the yes/no checkboxes on the
report so that they , instead, say "yes" or "no"???

 

[Keith Wilby]

I have a report based on a query that has yes/no checkboxes. Is there a
way
without using coding to allow me to translate the yes/no checkboxes on the
report so that they , instead, say "yes" or "no"???

Calculate it in your query:

Iif([MyField], "Yes","No")

Keith.
www.keithwilby.co.uk

 

[John Spencer]

For the relevant control, set its format property to the built-in "Yes/No"
format (no quotes).

Format: Yes/No


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

I have a report based on a query that has yes/no checkboxes. Is there
a way
without using coding to allow me to translate the yes/no checkboxes on
the
report so that they , instead, say "yes" or "no"???

Calculate it in your query:

Iif([MyField], "Yes","No")

Keith.
www.keithwilby.co.uk

 

[Keith Wilby]

For the relevant control, set its format property to the built-in "Yes/No"
format (no quotes).

Format: Yes/No


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Once again I am reminded of why I am not an MVP. Nice catch John, I don't
think I've ever used that property.

Keith.