P
Pwyd
I'm trying to keep some fields hidden on a data sheet so that they don't
print out, should someone choose to print out the records. Unfortunately, by
setitng them as hidden, i can no longer reference them on my form.
How can i prevent some field (check boxes, in this case) from printing out?
In addition, i have several commands that keep the fields invisible if
they're not being used, and setting the checkboxes associated with them to be
either on, or off, based on the contents of the field. IE:after importing
the data, if a field wasn't used, or if someone checks a checkbox and changes
to a new record, if nothing was entereed in the field, the checkbox unchecks
itself.
When i print any record, if i have any of the fields visible, it will print
ALL of the records as if they ALL had something in that field, even though
only one of the records had something typed in, in that field.
Also. When i start my form up, these same ".visible" settings are causing
an error: When designing the spreadsheet and looking at it in form view,
they worked fine. when i go to start up the database, and open the form, i
get the following error:
Run-time error '-2147352567 (800200009)':
You can't assign a value to this object.
Me.Check35 = Not (IsNull(Me.Text82))
i have the open form command in a macro, and when it first tries to open,
this is what i'm getting.
what gives?
print out, should someone choose to print out the records. Unfortunately, by
setitng them as hidden, i can no longer reference them on my form.
How can i prevent some field (check boxes, in this case) from printing out?
In addition, i have several commands that keep the fields invisible if
they're not being used, and setting the checkboxes associated with them to be
either on, or off, based on the contents of the field. IE:after importing
the data, if a field wasn't used, or if someone checks a checkbox and changes
to a new record, if nothing was entereed in the field, the checkbox unchecks
itself.
When i print any record, if i have any of the fields visible, it will print
ALL of the records as if they ALL had something in that field, even though
only one of the records had something typed in, in that field.
Also. When i start my form up, these same ".visible" settings are causing
an error: When designing the spreadsheet and looking at it in form view,
they worked fine. when i go to start up the database, and open the form, i
get the following error:
Run-time error '-2147352567 (800200009)':
You can't assign a value to this object.
Me.Check35 = Not (IsNull(Me.Text82))
i have the open form command in a macro, and when it first tries to open,
this is what i'm getting.
what gives?
