Changing record colour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Al

I would like to show records in grey colour if they have been archived. I have the field for marking whether the record is archived or not, but how do I change the font colour to grey for the whole record in datasheet view using VB codes

Many thanks
 
kev said:
I would like to show records in grey colour if they have been archived. I have the field for marking whether the record is archived or not, but how do I change the font colour to grey for the whole record in datasheet view using VB codes?
Click to expand...


You can't use a single setting for the entire record, but
you can use Conditional Formatting on each text box in the
detail section. Set its Expression Is to this kind of
thing:

Form.archived = True
 
Back
Top