Any way to stop the grey background on unbound Yes/No checkbox?

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

Guest

I have a report that prints where I don't track a Yes/No in the database.
However, once the report is printed, I want these few unbound checkboxes to
be there for the user to check if needed. Is there a way for these unbound
boxes to not be shaded grey inside them?

Thanks,

Richard
 
Richard said:
I have a report that prints where I don't track a Yes/No in the database.
However, once the report is printed, I want these few unbound checkboxes
to
be there for the user to check if needed. Is there a way for these
unbound
boxes to not be shaded grey inside them?
Click to expand...

Make the default value be False. The gray means Null is stored there before
a true or false value is put in.

Tom Lake
 
Tom,

thanks. That's exactly what I needed.

One other question if you don't mind. I have a text field with a two-item
list; "In-House" and "Out of House". Is there an expression where I can have
a specific checkbox "checked" if this one field is set to "Out of house" only?
 
Tom,
thanks. That's exactly what I needed.

One other question if you don't mind. I have a text field with a two-item
list; "In-House" and "Out of House". Is there an expression where I can
have
a specific checkbox "checked" if this one field is set to "Out of house"
only?
Click to expand...

In the AfterUpdate property of the text box, you could add code:

If Me!mytextboxname = "Out of House" Then
Me!mycheckboxname = True
Else
Me!mycheckboxname = False
End If

Of course change "mytextboxname" and "mycheckboxname" to the names of your
controls.

Tom Lake
 
awesome. thanks tom!!

Richard

Tom Lake said:
In the AfterUpdate property of the text box, you could add code:

If Me!mytextboxname = "Out of House" Then
Me!mycheckboxname = True
Else
Me!mycheckboxname = False
End If

Of course change "mytextboxname" and "mycheckboxname" to the names of your
controls.

Tom Lake
Click to expand...
 
Oops, One other question Tom.

I tried to enter the code. and I placed it in the AfterUpdate of the text
box. However, the checkbox is unbound, and only on the report.

After I added the code in my form, and then ran the report, the check box
was still empty. And I cannot add any events under that check box's property
since its unbound correct?
 
Back
Top