Removing checkbox in first empty record

  • Thread starter Thread starter Peter Bradley
  • Start date Start date
P

Peter Bradley

Hi all,

Is it possible to remove the checkbox for the first empty record in a
table. It's not a big deal, but I find it ugly in my forms. Thanks in
advanced.

PCB
 
Peter Bradley said:
Hi all,

Is it possible to remove the checkbox for the first empty record in a
table. It's not a big deal, but I find it ugly in my forms. Thanks in
advanced.
Click to expand...

I'm afraid I don't understand you. What check box are you talking
about? Where is it? When do you see it?
 
Dirk said:
I'm afraid I don't understand you. What check box are you talking
about? Where is it? When do you see it?
Click to expand...

Hi!

Create a table with one of the fields formatted as a 'yes/no' data type
and change the display control to 'check box'. The next record after the
last filled record also has a check box. This last check box always
shows up on forms as a greyed out check box. Hope this helps. Thanks again.

PCB
 
Peter Bradley said:
Hi!

Create a table with one of the fields formatted as a 'yes/no' data
type and change the display control to 'check box'. The next record
after the last filled record also has a check box. This last check
box always
shows up on forms as a greyed out check box. Hope this helps. Thanks
again.
Click to expand...

Okay, now I know what you are talking about. The box is greyed out
because, until you actually begin creating a new record, its value is
Null, and that's how a check box represents a Null value. You can make
it not be greyed (in the new record) out by setting the field's Default
Value property (in the table's Design View) to False.

If, for some reason, you don't want the check box to be visible at all
on the new record -- on a form -- that is fairly easy (requires VBA
code) if the form is in single-form view, quite difficult if the form is
in continuous-forms view, and not possible (AFAIK) if the form is in
datasheet view.
 
It is actually on a continuous form that I would like the last check
box not to be visible, but it sounds like it might not be worth the
effort. It was purely an aesthetic thing...nothing important. Thanks
again for the information.

PCB
 
Back
Top