List box Colours

  • Thread starter Thread starter Morgan Gartland via AccessMonster.com
  • Start date Start date
M

Morgan Gartland via AccessMonster.com

HI

I have a Form with a list box, when you double click a record in the list
box it opens in another Form showing all the details for that record.

I would like the colour of the record to change in the list box if any of
the details in the record details Form change. The idea is that i can see
what records have been updated and i can then deal with them.

Is this possible and can anyone give me an idea of how to do this?

This is still in the process of being created so i dont have any code to
post as of yet.
Thanks
Morgan
 
Hi Morgan

As far as I am aware, there is no way to produce variable formatting among
child records at all, except through Conditional Formatting. However, it
appears that Conditional Formatting is not available in list boxes. (It's
greyed out when you select one.)

You could use a continous form or a datasheet to display the child records
instead of a list box. If you add a new Boolean field to the table called
'Changed' or similar, perhaps when that record is updated, 'Changed' becomes
True instead of False. You could then set Conditional Formatting on the
continuous form or datasheet to set the colour of one or more of the listed
fields according to the value of 'Changed'.

A bit of an inelegant workaround, but I think it might work.

Cheers

David
 
Back
Top