How to disable data entry fields

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

Guest

I have a data entry form that displays in datasheet view. I have a checkbox
field called Issue. When the Issue field is left UNCHECKED I want a date
field named Completion Date and a checkbox field named FollowUp to be
disabled so no data entry can be inputted into those fields unless the Issue
checkbox is checked. How can I accomplish this?
 
I have a data entry form that displays in datasheet view. I have a checkbox
field called Issue. When the Issue field is left UNCHECKED I want a date
field named Completion Date and a checkbox field named FollowUp to be
disabled so no data entry can be inputted into those fields unless the Issue
checkbox is checked. How can I accomplish this?
Click to expand...

I'm not sure that you CAN, in datasheet view.

On a continous Form using AccessXP or later, you can use Conditional
Formatting on the controls, to enable or disable the control based on
the value of Issue. Use Format... Conditional Formatting from the
menu.

John W. Vinson[MVP]
 
Lorraine,

I'm with John. I've never figured out how to do this with a datasheet view.
But then, I avoid datasheet views like the plague. I find that you have
little or no control over user input, and absolutely no formatting control.
I prefer to use continuous forms, which give you conditional formatting, as
well as the ability to use combo boxes and other controls to achieve better
control over user input.

HTH
Dale
 
Lorraine said:
I have a data entry form that displays in datasheet view. I have a checkbox
field called Issue. When the Issue field is left UNCHECKED I want a date
field named Completion Date and a checkbox field named FollowUp to be
disabled so no data entry can be inputted into those fields unless the Issue
checkbox is checked. How can I accomplish this?
Click to expand...


I strongly prefer a continuous form, but Conditional
Formatting (Format menu) does work in datasheet view. Just
set the Expression Is expression to:
Not [Issue]
and select the enabled property.
 
Back
Top