C
carlsore
Is there a way to identify if conditional formatting is being applied
to a given field?
I have a form where I'm identifying missing mandatory data by using
conditional formatting to turn the field red. However, I have a
"Reviewed" field that needs to be checked after the data has been
verified by the user, and I want to code a quick check to make sure
none of the mandatory data is missing before allowing them to move on.
The list of mandatory fields is conditionally linked to another field
on the record (ie: if you buy a product, you have to supply a vendor
name; if you make it, you don't), so I can't go directly to the field
names without a massive Select Case/If Then combo.
I know that you can use .FormatConditions to view the settings, but
the .BackColor of the field itself only shows its default value.
to a given field?
I have a form where I'm identifying missing mandatory data by using
conditional formatting to turn the field red. However, I have a
"Reviewed" field that needs to be checked after the data has been
verified by the user, and I want to code a quick check to make sure
none of the mandatory data is missing before allowing them to move on.
The list of mandatory fields is conditionally linked to another field
on the record (ie: if you buy a product, you have to supply a vendor
name; if you make it, you don't), so I can't go directly to the field
names without a massive Select Case/If Then combo.
I know that you can use .FormatConditions to view the settings, but
the .BackColor of the field itself only shows its default value.