Form Screen Flicker (1 Viewer)

[phillip]

Need a little help from the experts. I’m trying to find a good way to highlight the entire row (on a form) when the user clicks on the record. Currently I am using conditional formatting on each of the fields/controls on the form. The expression is: [ID]=[txtSelectedRecord] which turns each of the fields back ground color to yellow.

This works fine except that there is a form screen “flicker” each time the user clicks on a different record.

I’m trying to find a better way to highlight the row and eliminate the screen flicker.

Attached is a sample database and thanks in advance.

 

[DHookom]

I believe this was recently discussed in this thread.

 

[XPS35]

Please provide a database that is working.

 

[isladogs]

Various solutions are possible. For example:

Highlight Current Record Using Transparency

This shows a simple way of using the transparency property for a button or line border to highlight the current record in a continuous form.

www.isladogs.co.uk

Highlight Current Record in Continuous Form

This example database shows how you can easily highlight the current record in a continuous form. The same approach is also demonstrated for an emulated split form.

www.isladogs.co.uk

 

[phillip]

Please provide a database that is working.

I attached the database - it is in the zip file ScreenFlicker.zip in my original post

 

[arnelgp]

here test your db.
i arrange the Tab order and also add ControlSource to textbox txtSelectedRecord.

 

[phillip]

here test your db.
i arrange the Tab order and also add ControlSource to textbox txtSelectedRecord.

Thanks for the help, but in the db you edited for me all of the records highlight in yellow, not just the row that is selected.

 

[arnelgp]

here this time this has highlight and without flicker.

 

[phillip]

here this time this has highlight and without flicker.

thank you, my friend - that did it