Well, the easiest way to deal with the lables is to simply
get rid of them and make another copy your textbox that
generates the symbol. Replace the R with the proper text
and use a "real" font.
As for where it came from, I honestly don't remember.
I've been using variations of this for many years, on both
forms and reports. It likely came from something somebody
posted on this newsgroup long long ago, but unfortunately
I don't know who to give the proper credit.
Rob.
>-----Original Message-----
>One more question - what can be done about the labels for
these checkboxes? I wouldn't want them to display either
unless the checkbox was selected.
>
>Thanks!
>
>"Rob" wrote:
>
>> There is a way to do this without code, by using IIF()
and
>> getting creative with your font selection.
>>
>> Place an unbound text box on the report, and then set
its
>> Control Source to:
>>
>> =IIF([Forms]![formname]![checkboxname],"R")
>>
>> Then change the font for this text box to WingDings2.
The
>> result will be nothing if the checkbox on the form is
not
>> set, and a square with a checkmark in it if the
checkbox
>> is set.
>>
>> To use a different graphic, you can change the R to a
>> different letter and/or select a different symbol font.
>>
>> Rob
>>
>>
>>
>> >-----Original Message-----
>> >I have a parameter query tied to a form, that then
prints
>> out its results in a report. There are many checkboxes
on
>> the form. I would like the report to display the
checkbox
>> if the checkbox is selected in the form, if not, I
don't
>> want the checkbox to display. I'm thinking this can be
>> accomplished with a simple vb code, but I don't know vb
>> very well.
>> >
>> >Any help is appreciated.
>> >
>> >
>> >.
>> >
>>
>.
>
|
Similar Threads
