yes/no checkboxes

  • Thread starter Thread starter Pearl
  • Start date Start date
P

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"???
 
Pearl said:
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"???
Click to expand...

Calculate it in your query:

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

Keith.
www.keithwilby.co.uk
 
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

Keith said:
Pearl said:
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"???
Click to expand...

Calculate it in your query:

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

Keith.
www.keithwilby.co.uk
Click to expand...
 
John Spencer said:
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
Click to expand...

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.
 
Back
Top