Well, I'm stumped!

  • Thread starter Thread starter Sandra S
  • Start date Start date
S

Sandra S

Is there a way to format or program a form so that if, for
example, you have a check box with label and the answer
is "no" that you can make it NOT show on the printed
form? I only want to show those checks that have a "yes"
answer. I've tried doing it with the query
showing "false" as a filter, but there are quite a few
questions and I get an error message telling me that I'm
using too many fields.
 
Not sure what you are asking here.

Forms are used to view, edit, and add data. If you want to print, you need
to build a report. The report would be based on a query that would specify
the criterria for the records to report.

Rick B



Is there a way to format or program a form so that if, for
example, you have a check box with label and the answer
is "no" that you can make it NOT show on the printed
form? I only want to show those checks that have a "yes"
answer. I've tried doing it with the query
showing "false" as a filter, but there are quite a few
questions and I get an error message telling me that I'm
using too many fields.
 
are you printing the form itself? if so, trying adding the following code to
each checkbox's AfterUpdate event, and also to the form's OnCurrent event,
as

If Me!CheckBoxName Then
Me!CheckBoxName.DisplayWhen = 0
Else
Me!CheckBoxName.DisplayWhen = 2
End If

if you're printing the records in a report, the above won't work. for a
report, i think you can set each checkbox control's Visible property to True
or False based on the value in each record, but i'm not sure if you would
run that from the report's OnOpen event, or possibly the Page event. if
nobody else posts what you need in a day or two, suggest you repost the
question under the Access Reports user group.

hth
 
Back
Top