Can I highlight records on a form?

[gavintennant]

Hi,

Can anyone tell me if it's possible to highlight records in a form?
Basically, on a form, I have several text boxes set up to view the records. It would make it easier for the users of the database to see at a glance which of these changed with each recordset (or which did not change?) I presume I would have to look at the queries involved but am not sure how to go about checking for changes?
Can anyone give me any ideas or pointers??

Thanks very much
Gavin

 

[HenryAnthony]

Hi Gavin,

Yes it is possible to highlight records in a form. You can test a condition with an "If then" statement and use it to set the background color.

But, what criteria would you use to determine a changed or unchanged record? A bit more information would be helpful in formulating a solution to your problem.

Also, something to think about, if a changed record was highlighted, and all records changed, everything would be highlighted thereby defeating the strategy.

Best regards,

Henr¥

 

[gavintennant]

Hi Henry,

Thanks for that tip, I'll try and give you a bit more information now!!

I would like to highlight the text boxes if through the whole of the recordset, or the result of the query, an individual paramter remains constant. Say the source of the form is a query with 20 fields coming back with 30 records, I would like to look through each field in all records and flag up if the whole field is the same (or changes) over the query. On the form, this text box would then be highlighted.

On each form there is for example 10 different text boxes but in this maybe only 3 or 4 would change through the whole of the recordset, but with results approaching 30 or 40 different records then you can maybe see why it would be useful to identify the ones that don't change.

You are right, for some forms everything changes with each record but only on very few forms. I would tend to leave this functionality out of these forms but in general for the rest of the database I think it would be a useful feature.

Thanks again for your help, hopefully I've managed to clarify a few things here??

Gavin

 

[HenryAnthony]

Gavin,

From a post related to your problem:

<<Access tracks schema update dates but not data update dates. You'll need to create a table to track update data and time. You can then query that table for the last modified date on your form.>>

Without a condition to test for, all you have to work with is BeforeUpdate and AfterUpdate. You could then use if/then to switch the color.

Hope this helps.

Best regards,

Henr¥