display yes/no field on report as graphic/picture

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When printing a yes/no data type field on a report, if the field value is Yes
print a graphic instead of the check box.
 
When printing a yes/no data type field on a report, if the field value is Yes
print a graphic instead of the check box.
Click to expand...

Do you want to show the check box if the value is No?

You can place the graphic in the report where you want it to print,
then code the Detail Section's Format event:
ImageName.Visible = [CheckBoxField] = -1
[CheckBoxField].Visible = [CheckBoxField] = 0
 
I have to ask the User what they want if NO.

Thanks for the help!

fredg said:
When printing a yes/no data type field on a report, if the field value is Yes
print a graphic instead of the check box.
Click to expand...

Do you want to show the check box if the value is No?

You can place the graphic in the report where you want it to print,
then code the Detail Section's Format event:
ImageName.Visible = [CheckBoxField] = -1
[CheckBoxField].Visible = [CheckBoxField] = 0
Click to expand...
 
Replace the check box with a text box.

Set the Format property of the text box to give the graphic you want.

For example if you want to show an unboxed checkmark for Yes and a blank
space for No, you could set the font for the text box to WingDings, and type
these three characters:
backslash
semicolon
hold down Alt, and type 0252 on the numeric keypad.
 
Back
Top