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
|
|||
|
|||
Check boxes
I have check boxes on a form. When I check a box, save the form, close the
form and then re-open the check is not present anymore. Also, when i check a box and then go to a new record, the checks follow. If I edit the check on the new record, they are edited on the previour record. How do I prevent these issues? Thanks -- Drock-13 |
#2
|
|||
|
|||
Check boxes
It sounds as if you have an unbound check box. You need to bind it to a
yes/no field. It could be another field type in some cases, but the point is that it needs to be bound to a field in order for the value to be saved. To see this property, open the form in Design view, click the check box to select it, click View Properties, click the Data tab, and look at the Control Source line. "smeldawg" wrote in message ... I have check boxes on a form. When I check a box, save the form, close the form and then re-open the check is not present anymore. Also, when i check a box and then go to a new record, the checks follow. If I edit the check on the new record, they are edited on the previour record. How do I prevent these issues? Thanks -- Drock-13 |
#3
|
|||
|
|||
Check boxes
That has worked to tie the checks to the appropriate form, but now the yes/no
fields that I binded it to are being changed to a -1 or 0 once the box is checked. how do I change that? Thanks -- Drock-13 "BruceM" wrote: It sounds as if you have an unbound check box. You need to bind it to a yes/no field. It could be another field type in some cases, but the point is that it needs to be bound to a field in order for the value to be saved. To see this property, open the form in Design view, click the check box to select it, click View Properties, click the Data tab, and look at the Control Source line. "smeldawg" wrote in message ... I have check boxes on a form. When I check a box, save the form, close the form and then re-open the check is not present anymore. Also, when i check a box and then go to a new record, the checks follow. If I edit the check on the new record, they are edited on the previour record. How do I prevent these issues? Thanks -- Drock-13 |
#4
|
|||
|
|||
Check boxes
Open the table in design view. Click the field in question. Is its Data
Type listed as Yes/No? If so, at the bottom left of the window click the Format tab, and change Display Control to Check Box. If the Format on the General tab is blank and the Display Control is a text box, a Yes/No field will display as -1 or 0. If the Format is set to Yes/No and the Display Control is a text box the field will be displayed as Yes or No. Same idea for True/False and On/Off. However, if the Display Control is a check box then the Format does not affect the display. Access stores the information as 0 or -1, so it shouldn't matter how it is displayed in the table, except for the developer's convenience or preference. Users shouldn't see the table in any case. "smeldawg" wrote in message ... That has worked to tie the checks to the appropriate form, but now the yes/no fields that I binded it to are being changed to a -1 or 0 once the box is checked. how do I change that? Thanks -- Drock-13 "BruceM" wrote: It sounds as if you have an unbound check box. You need to bind it to a yes/no field. It could be another field type in some cases, but the point is that it needs to be bound to a field in order for the value to be saved. To see this property, open the form in Design view, click the check box to select it, click View Properties, click the Data tab, and look at the Control Source line. "smeldawg" wrote in message ... I have check boxes on a form. When I check a box, save the form, close the form and then re-open the check is not present anymore. Also, when i check a box and then go to a new record, the checks follow. If I edit the check on the new record, they are edited on the previour record. How do I prevent these issues? Thanks -- Drock-13 |
Thread Tools | |
Display Modes | |
|
|