Is there a way not to print fields in reports that do not have any data?
I've developed a form with checkboxes where the user either checks the box
for "yes" or leaves it blank for "no". Is there a way to print only the
boxes that contain a check box on my report? I don't want to see the blank
records?

Thank you.

In the reports details section's format event:
if Me.Checkbox = True
Me.Checkbox.Visible = True
Else
Me.Checkbox.Visible = False
End If
--
hth,
SusanV


"Katie" <(E-Mail Removed)> wrote in message
news:F0283077-7387-40D1-9F2F-(E-Mail Removed)...
> Is there a way not to print fields in reports that do not have any data?
> I've developed a form with checkboxes where the user either checks the box
> for "yes" or leaves it blank for "no". Is there a way to print only the
> boxes that contain a check box on my report? I don't want to see the
> blank
> records?
>
> Thank you.

Oops forgot the "Then":

if Me.Checkbox = True Then
Me.Checkbox.Visible = True
Else
Me.Checkbox.Visible = False
End If



"SusanV" <(E-Mail Removed)> wrote in message
news:u%(E-Mail Removed)...
> In the reports details section's format event:
> if Me.Checkbox = True
> Me.Checkbox.Visible = True
> Else
> Me.Checkbox.Visible = False
> End If
> --
> hth,
> SusanV
>
>
> "Katie" <(E-Mail Removed)> wrote in message
> news:F0283077-7387-40D1-9F2F-(E-Mail Removed)...
>> Is there a way not to print fields in reports that do not have any data?
>> I've developed a form with checkboxes where the user either checks the
>> box
>> for "yes" or leaves it blank for "no". Is there a way to print only the
>> boxes that contain a check box on my report? I don't want to see the
>> blank
>> records?
>>
>> Thank you.
>
>

Perfect! This is exactly what I was looking for. Thank you.

"SusanV" wrote:

> In the reports details section's format event:
> if Me.Checkbox = True
> Me.Checkbox.Visible = True
> Else
> Me.Checkbox.Visible = False
> End If
> --
> hth,
> SusanV
>
>
> "Katie" <(E-Mail Removed)> wrote in message
> news:F0283077-7387-40D1-9F2F-(E-Mail Removed)...
> > Is there a way not to print fields in reports that do not have any data?
> > I've developed a form with checkboxes where the user either checks the box
> > for "yes" or leaves it blank for "no". Is there a way to print only the
> > boxes that contain a check box on my report? I don't want to see the
> > blank
> > records?
> >
> > Thank you.
>
>
>

Glad to help when I can!

;-)


"Katie" <(E-Mail Removed)> wrote in message
news:122A7B6A-1F78-4B07-90F8-(E-Mail Removed)...
> Perfect! This is exactly what I was looking for. Thank you.
>
> "SusanV" wrote:
>
>> In the reports details section's format event:
>> if Me.Checkbox = True
>> Me.Checkbox.Visible = True
>> Else
>> Me.Checkbox.Visible = False
>> End If
>> --
>> hth,
>> SusanV
>>
>>
>> "Katie" <(E-Mail Removed)> wrote in message
>> news:F0283077-7387-40D1-9F2F-(E-Mail Removed)...
>> > Is there a way not to print fields in reports that do not have any
>> > data?
>> > I've developed a form with checkboxes where the user either checks the
>> > box
>> > for "yes" or leaves it blank for "no". Is there a way to print only
>> > the
>> > boxes that contain a check box on my report? I don't want to see the
>> > blank
>> > records?
>> >
>> > Thank you.
>>
>>
>>