Problem checkbox won't go away

  • Thread starter Thread starter test guy
  • Start date Start date
T

test guy

At one time, the list of values from my query showed a checkbox value which
was never actually used in my report. Now that I've modified the query so
that checkbox field isn't included, that checkbox still shows up on my
report, even though I can't find it in the Design view! I can't see it in
design, but it shows up in the preview.. why???
 
What do you mean it shows up in your report.
Do you actually see the check box square (with or without the check)?
Or do you get a prompt for a value?

If you actually see the check box, in design view find the check box name in
the Object drop down. Click on it and the check box will be selected. Now
you can delete it from the report.

If you get a prompt for a value, then you either have code that calls for
the checkbox field value, or you have a reference to it in either the
sorting and grouping dialog which you forgot to delete, or in a control
source expression of a control calls for it.
 
It sounds like you might have changed the control source
for the check box on the report to a new control. Try
deleting the check box on the report ad adding the new
field again.

Jim
 
Back
Top