Can a field be activated based on another field

[Marc]

I have a pretty simple database set up with clients in the accounting firm in
which I work. Some of the clients have to file sales tax and some don't.
The ones that do file either quarterly or monthly.

I have a yes/no field asking about sales tax. I only want the field for
monthly/quarterly to be active if the answer is yes.

Thanks for any help.

 

[Luiz Cláudio C. V. Rocha [MVP]]

Hi Marc,

you can use conditional formatting to enable/disable a field according to an
expression (such as [YourYesNoField]=0).

 

[Marc]

Hey Luiz -
Thanks for responding so quickly. Ok, now my question is where do I enter
the conditional formatting? Under enable I can only choose yes or no.

I appreciate your time.

Marc

Hi Marc,

you can use conditional formatting to enable/disable a field according to an
expression (such as [YourYesNoField]=0).


--
Luiz Cláudio C. V. Rocha
São Paulo - Brasil
http://br.thespoke.net/MyBlog/lccvr/MyBlog.aspx

I have a pretty simple database set up with clients in the accounting firm
in
which I work. Some of the clients have to file sales tax and some don't.
The ones that do file either quarterly or monthly.

I have a yes/no field asking about sales tax. I only want the field for
monthly/quarterly to be active if the answer is yes.

Thanks for any help.

 

[John Vinson]

Hey Luiz -
Thanks for responding so quickly. Ok, now my question is where do I enter
the conditional formatting? Under enable I can only choose yes or no.

PMFJI... select the textbox or other control that you want to
conditionally enable. On the menu select Format... Conditional
Formatting. You'll need to use the Expression option for the
criterion; make it "Enabled = Yes" if you want it to be a live
control, Enabled = No if you want it blocked.


John W. Vinson[MVP]

 

[Marc]

Hi John -

Thanks for joining in. I found the conditional formatting section you
mentioned. Now I want the conditions of field 'A' based on a yes/no field
'B'.

Can you lend further support?

Marc

 

[John Vinson]

Hi John -

Thanks for joining in. I found the conditional formatting section you
mentioned. Now I want the conditions of field 'A' based on a yes/no field
'B'.

Can you lend further support?

Sure - use the "Expression" option rather than the field value, and
use an expression

= True

John W. Vinson[MVP]

 

[Marc]

John-
Got it! Now, if the status of field 'A' changes to false, can the cell be
disabled and cleared?
I really appreciate your time.

What does 'MVP' stand for?
Marc

Hi John -

Thanks for joining in. I found the conditional formatting section you
mentioned. Now I want the conditions of field 'A' based on a yes/no field
'B'.

Can you lend further support?

Sure - use the "Expression" option rather than the field value, and
use an expression

= True

John W. Vinson[MVP]

 

[John Vinson]

John-
Got it! Now, if the status of field 'A' changes to false, can the cell be
disabled and cleared?
I really appreciate your time.

Use the AfterUpdate event of field A - you can't do this with
conditional formatting. E.g.

Private Sub txtA_AfterUpdate()
If Me!txtA = False Then
Me!txtB = Null
Me!txtB.Enabled = False
End If
End Sub

What does 'MVP' stand for?

Most Valuable Professional, a recognition from Microsoft which quite a
few of the frequent answerers here have been awarded: see



for an overview.

John W. Vinson[MVP]