G
Guest
I need a multi-line form to display items to a main form. So I have added a
sub-form onto the main form and used a relational linked table with seperate
records for each item (or line) in the sub-form.
My problem arises in that I have to highlight problem records by changing
the colours of a field based on it's value. I have added code to the
continuous form and it does check the value, but it changes the whole column
instead of each just by each record.
To illustrate: If column one reads greater than 2 then the second column's
font must be uppercase.
1 e
2 h
0 f
4 G
3 T
etc.
How can this be done? Can anyone help please.
sub-form onto the main form and used a relational linked table with seperate
records for each item (or line) in the sub-form.
My problem arises in that I have to highlight problem records by changing
the colours of a field based on it's value. I have added code to the
continuous form and it does check the value, but it changes the whole column
instead of each just by each record.
To illustrate: If column one reads greater than 2 then the second column's
font must be uppercase.
1 e
2 h
0 f
4 G
3 T
etc.
How can this be done? Can anyone help please.