If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Any way to stop the grey background on unbound Yes/No checkbox?
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 |
#2
|
|||
|
|||
"Richard" wrote in message
... 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? Make the default value be False. The gray means Null is stored there before a true or false value is put in. Tom Lake |
#3
|
|||
|
|||
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 Lake" wrote: "Richard" wrote in message ... 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? Make the default value be False. The gray means Null is stored there before a true or false value is put in. Tom Lake |
#4
|
|||
|
|||
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? 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 |
#5
|
|||
|
|||
awesome. thanks tom!! Richard "Tom Lake" wrote: 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? 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 |
#6
|
|||
|
|||
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? "Tom Lake" wrote: 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? 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Yes/No boxes in forms | Stephen Glynn | New Users | 14 | May 30th, 2004 07:25 PM |