Color field depending on person who updated it ...

[Guest]

In a subform (Continuous Forms) I allow different people of our workgroup to
update the fields. Each person a color code. Every time this person makes a
change/update, the field should appear in the forecolor of this person. But
only the field in the specific record that was updated.

Any ideas???

I tried this by adding an additional field for every field that is
updatable. This field is not visible and will have the UserName of the person
who updated the field.
But I have difficulties to color-code the field (the ON CURRENT, ON OPEN
function does not set the foreground at the time the subform is opened.

 

[Ken Snell \(MVP\)]

Perhaps Conditional Formatting will work for you? Take a look at it in Help
then post back with additional questions....

 

[Guest]

Thanks, that worked. Beside there are max. 3 conditions. I do need more. Is
there any way? Do you know?

 

[Ken Snell \(MVP\)]

Conditional Formatting is limited to three separate tests.

However, Stephen Lebans (MVP) has a large number of specialized features at
his website ( www.lebans.com ). Take a look there and see if one of them
might be useful for you.

If not, then you can use VBA code to set the format of various controls on a
record, using the form's Current event. However, note that such formatting
will be displayed on all records; and then will change on all records when
you go to a different record.

 

[Guest]

Thanks, I will look at lebans.com.

Yes, that was my problem with VBA code. They all change and I need a
continous list or datasheet view. So, there is no solution for that?

Also: When I am using the conditional formatting, it works if I open the
form with my list. But when I use the form as a subform, the conditions don't
show up. Does anyone know about anything about this???

Thanks a lot in advance.

 

[Ken Snell \(MVP\)]

When you use the form as a subform, likely the conditions' expressions are
using references that are no longer valid for the form as a subform.
Subforms must be referenced through the main form; they cannot be referenced
as if they were a form because they are not "open" as a form -- they exist
as part of the parent form.

You'll need to post an example of the condition's expression so that we can
see what you're using.

As for "solution" for the continuous forms view, etc. -- there is no "fix"
for that in ACCESS; that is just how ACCESS renders forms -- namely, there
is actually only one control in the form, not multiple controls for the
multiple records, so whatever is done to one by VBA code changing the
properties of the control is done to all that you see. Conditional
formatting is the only workaround that's built in.