Conditionally Enable Controls

G

Guapo

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?
 
R

Ron2005

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
 
S

Sprinks

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
 
G

Guapo

Can the conditional formatting be based on the value in a different control
and change the enable properties by individual record in continuous form?
 
S

Sprinks

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
 
M

Mary

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
 
Top