In a continuous form, Access has just one set of control
properties for all the records displayed. This means that changes to any control's
property will affect all records.
But you probably already knew that if you were trying to either
highlight a particular record from code, or setting the Backcolor of a textbox based on
While the above is true and cannot be changed, you can use the
Format property (search Access Help on those keywords) to conditionally change the color
of a textbox.
Luckily, while cleaning one of my hard drives, I found a
database that I had downloaded off the 'net many moons ago. Unfortunately, I
don't have the URL or the name of its creator, so I cannot properly acknowledge the
individual. However, if the creator who installed Access with the Name of "University Facilities" and company "Youngstown State University" ever come across
this page, please drop me an email!!
A sample database is worth more than what I can describe here.
So here you go....