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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Checkbox Fields For Every Record 0
Access Daily Entry with multiple entries per field 0
Problem with disable/enable related field 2
Required Field based on another Field 5
set checkbox condition based on compared field values 3
Increment a Short Time Field by 15 minutes 2
set checkbox condition based on comparing two fields 6
Conditional Formating for each Record 1

Back
Top