Dim out fields

  • Thread starter Thread starter RipperT
  • Start date Start date
R

RipperT

Is there a way to dim out a field (remains visible but
unavailable) based upon the value of another field?
Rip
 
In Access 2000 and later, you can disable a field based on the value of
another field with Conditional Formatting.

1. In form design view, select the field to be disabled.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression is ... [Amount] > 1000
and then click the Enabled button (right side of Conditional Formatting
dialog).

That example disables the select field if the condition is true, i.e. if the
Amount field is greater than 1000.
 
Thank you, but I want to enable or disable the field in
question based on the value in ANOTHER field. Will I have
to create an expression to enter in the condition box
that refers to the other field?

Rip

-----Original Message-----
In Access 2000 and later, you can disable a field based on the value of
another field with Conditional Formatting.

1. In form design view, select the field to be disabled.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression is ... [Amount] > 1000
and then click the Enabled button (right side of Conditional Formatting
dialog).

That example disables the select field if the condition is true, i.e. if the
Amount field is greater than 1000.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Is there a way to dim out a field (remains visible but
unavailable) based upon the value of another field?
Rip
Click to expand...


.
Click to expand...
 
First, in the On Current event of the form, check for the value of the field
and then set the attributes of the other controls as needed.

Private Sub Form Current()
If [nameofcontrolwithvalue] = "the value" Then

[othercontrol].Enable = False 'Disable othercontrol

Else

[othercontrol].Enable = True 'Enablae other control

End If

End Sub

Second, you also need to disable/enable when a user changes
[nameofcontrolwithvalue] by using the After Update event of the control.

Private Sub nameofcontrolwithvalue_AfterUpdate()

If [nameofcontrolwithvalue] = "the value" Then

[othercontrol].Enable = False 'Disable othercontrol

Else

[othercontrol].Enable = True 'Enablae other control

End If

End Sub


JohnC


RipperT said:
Thank you, but I want to enable or disable the field in
question based on the value in ANOTHER field. Will I have
to create an expression to enter in the condition box
that refers to the other field?

Rip

-----Original Message-----
In Access 2000 and later, you can disable a field based on the value of
another field with Conditional Formatting.

1. In form design view, select the field to be disabled.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression is ... [Amount] > 1000
and then click the Enabled button (right side of Conditional Formatting
dialog).

That example disables the select field if the condition is true, i.e. if the
Amount field is greater than 1000.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Is there a way to dim out a field (remains visible but
unavailable) based upon the value of another field?
Rip
Click to expand...


.
Click to expand...
Click to expand...
 
Yes, that's right.

The example showed how to disable field "B" based on the value in field
"Amount". Conditional formatting can do that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

RipperT said:
Thank you, but I want to enable or disable the field in
question based on the value in ANOTHER field. Will I have
to create an expression to enter in the condition box
that refers to the other field?

Rip

-----Original Message-----
In Access 2000 and later, you can disable a field based on the value of
another field with Conditional Formatting.

1. In form design view, select the field to be disabled.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression is ... [Amount] > 1000
and then click the Enabled button (right side of Conditional Formatting
dialog).

That example disables the select field if the condition is true, i.e. if the
Amount field is greater than 1000.


Is there a way to dim out a field (remains visible but
unavailable) based upon the value of another field?
Rip
Click to expand...
Click to expand...
Click to expand...
 
Oops. My fault. I misread your example. Thanx for your
help. You guys are really getting me thru this!

Rip
-----Original Message-----
Yes, that's right.

The example showed how to disable field "B" based on the value in field
"Amount". Conditional formatting can do that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thank you, but I want to enable or disable the field in
question based on the value in ANOTHER field. Will I have
to create an expression to enter in the condition box
that refers to the other field?

Rip

-----Original Message-----
In Access 2000 and later, you can disable a field based on the value of
another field with Conditional Formatting.

1. In form design view, select the field to be disabled.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression is ... [Amount] > 1000
and then click the Enabled button (right side of Conditional Formatting
dialog).

That example disables the select field if the condition is true, i.e. if the
Amount field is greater than 1000.


"RipperT" <[email protected]> wrote
Click to expand...
in
message
Is there a way to dim out a field (remains visible but
unavailable) based upon the value of another field?
Rip
Click to expand...
Click to expand...


.
Click to expand...
 
Excellent information. Thanx for your help!
Rip
-----Original Message-----
First, in the On Current event of the form, check for the value of the field
and then set the attributes of the other controls as needed.

Private Sub Form Current()
If [nameofcontrolwithvalue] = "the value" Then

[othercontrol].Enable = False 'Disable othercontrol

Else

[othercontrol].Enable = True 'Enablae other control

End If

End Sub

Second, you also need to disable/enable when a user changes
[nameofcontrolwithvalue] by using the After Update event of the control.

Private Sub nameofcontrolwithvalue_AfterUpdate()

If [nameofcontrolwithvalue] = "the value" Then

[othercontrol].Enable = False 'Disable othercontrol

Else

[othercontrol].Enable = True 'Enablae other control

End If

End Sub


JohnC


Thank you, but I want to enable or disable the field in
question based on the value in ANOTHER field. Will I have
to create an expression to enter in the condition box
that refers to the other field?

Rip

-----Original Message-----
In Access 2000 and later, you can disable a field based on the value of
another field with Conditional Formatting.

1. In form design view, select the field to be disabled.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression is ... [Amount] > 1000
and then click the Enabled button (right side of Conditional Formatting
dialog).

That example disables the select field if the condition is true, i.e. if the
Amount field is greater than 1000.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"RipperT" <[email protected]> wrote
Click to expand...
in
message
Is there a way to dim out a field (remains visible but
unavailable) based upon the value of another field?
Rip


.
Click to expand...
Click to expand...



.
Click to expand...
 
I would actually like to use any of several distinct
values in the field, but I don't know what the syntax is.
This wouldn't work:

Private Sub Form Current()
If [nameofcontrolwithvalue] = "the value" Or "the
other value" Or "the other value" Then...

Do I need to separate each with a comma or some other
separator? Or, alternatively, can I use IsNull so that if
ANYTHING is in the field, the others are affected? If so,
what would be the correct syntax?

Thanx a million.

Ripper
-----Original Message-----
First, in the On Current event of the form, check for the value of the field
and then set the attributes of the other controls as needed.

Private Sub Form Current()
If [nameofcontrolwithvalue] = "the value" Then

[othercontrol].Enable = False 'Disable othercontrol

Else

[othercontrol].Enable = True 'Enablae other control

End If

End Sub

Second, you also need to disable/enable when a user changes
[nameofcontrolwithvalue] by using the After Update event of the control.

Private Sub nameofcontrolwithvalue_AfterUpdate()

If [nameofcontrolwithvalue] = "the value" Then

[othercontrol].Enable = False 'Disable othercontrol

Else

[othercontrol].Enable = True 'Enablae other control

End If

End Sub


JohnC


Thank you, but I want to enable or disable the field in
question based on the value in ANOTHER field. Will I have
to create an expression to enter in the condition box
that refers to the other field?

Rip

-----Original Message-----
In Access 2000 and later, you can disable a field based on the value of
another field with Conditional Formatting.

1. In form design view, select the field to be disabled.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression is ... [Amount] > 1000
and then click the Enabled button (right side of Conditional Formatting
dialog).

That example disables the select field if the condition is true, i.e. if the
Amount field is greater than 1000.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"RipperT" <[email protected]> wrote
Click to expand...
in
message
Is there a way to dim out a field (remains visible but
unavailable) based upon the value of another field?
Rip


.
Click to expand...
Click to expand...



.
Click to expand...
 
For anything in the field:

If Not IsNull(nameofcontrolwithvalue.Value) Then

To check for several values you can use ElseIf

If [nameofcontrolwithvalue] = "valueone" Then
[othercontrol].Enable = False

ElseIf [nameofcontrolwithvalue] = "valuetwo" Then
[othercontrol].Enable = False

ElseIf
.....
Else
.....
End If


RipperT said:
I would actually like to use any of several distinct
values in the field, but I don't know what the syntax is.
This wouldn't work:

Private Sub Form Current()
If [nameofcontrolwithvalue] = "the value" Or "the
other value" Or "the other value" Then...

Do I need to separate each with a comma or some other
separator? Or, alternatively, can I use IsNull so that if
ANYTHING is in the field, the others are affected? If so,
what would be the correct syntax?

Thanx a million.

Ripper
-----Original Message-----
First, in the On Current event of the form, check for the value of the field
and then set the attributes of the other controls as needed.

Private Sub Form Current()
If [nameofcontrolwithvalue] = "the value" Then

[othercontrol].Enable = False 'Disable othercontrol

Else

[othercontrol].Enable = True 'Enablae other control

End If

End Sub

Second, you also need to disable/enable when a user changes
[nameofcontrolwithvalue] by using the After Update event of the control.

Private Sub nameofcontrolwithvalue_AfterUpdate()

If [nameofcontrolwithvalue] = "the value" Then

[othercontrol].Enable = False 'Disable othercontrol

Else

[othercontrol].Enable = True 'Enablae other control

End If

End Sub


JohnC


Thank you, but I want to enable or disable the field in
question based on the value in ANOTHER field. Will I have
to create an expression to enter in the condition box
that refers to the other field?

Rip


-----Original Message-----
In Access 2000 and later, you can disable a field based
on the value of
another field with Conditional Formatting.

1. In form design view, select the field to be disabled.

2. Choose Conditional Formatting on the Format menu.

3. Set Condition 1 to:
Expression is ... [Amount] > 1000
and then click the Enabled button (right side of
Conditional Formatting
dialog).

That example disables the select field if the condition
is true, i.e. if the
Amount field is greater than 1000.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

message
Is there a way to dim out a field (remains visible but
unavailable) based upon the value of another field?
Rip


.
Click to expand...



.
Click to expand...
Click to expand...
 
Back
Top