Conditionally Enable Controls

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

Guest

I have a datasheet form. I want to have a controls properties change based
on information from another control.

I would like to have the same column in my Datasheet form have enabled and
disabled cells depending on other information within the record.

Is there a way to do this?
 
Check out the Conditional formating when on the form in design view.
=================
Example:
On form I have
Field1
Field2 has value of "A" or "B"
Field3

Conditional formating for Field3 could ready
expression [Field2]="B" then formating
be Disabled
======================
When viewing the form, whenever Field2 was equal to "B" then Field3
would be disabled.

Ron
 
Guapo,

Datasheet view is very limited as to your control of its appearance. You
can, however, use conditional formatting (Format, Conditional Formatting) on
a continuous form.

Hope that helps.
Sprinks
 
Can the conditional formatting be based on the value in a different control
and change the enable properties by individual record in continuous form?
 
Yes.

Choose Format, Conditional Formatting after selecting the control. Select
"Expression Is" from the dropdown box of Condition1, and set the format you'd
like.

Cool, eh?

Sprinks
 
Will this work with a command button on a form? If so, where do I put the
expression?

On my form I have a textbox that is populated with the current user id. My
command button (which opens another form) should only be enabled for 3 users,
otherwise disabled.

Thanks!
Mary
 
Back
Top