SteveL13

<div>
it is always possible. &nbsp;The question is .... is it practical.<br />
<br />
Sometimes the best way to handle it is to create a pretend form. &nbsp;using a table, report, or other object that allows what you want easily and mimic's form behavior using code.
</div>


it is always possible.  The question is .... is it practical.

Sometimes the best way to handle it is to create a pretend form.  using a table, report, or other object that allows what you want easily and mimic's form behavior using code.

<div>
<div class="content wysiwyg-content">
I'm not sure if this is possible. &nbsp;I want to highlight a row in a datasheet view form if the following situation exists. &nbsp;The form has tblEstimateNotes as its record source.<br />
<br />
There are two tables. &nbsp;One is named tblCustomerAutoNotes and the other one is named tblEstimateNotes. &nbsp;If any one value of <i>fieldname</i> in a row in tblEstimateNotes MATCHES the value of <i>fieldname </i>in tblCustomerAutoNotes then make the background color of that row a light green.<br />
<br />
Possible?
</div>
</div>


I'm not sure if this is possible.  I want to highlight a row in a datasheet view form if the following situation exists.  The form has tblEstimateNotes as its record source.

There are two tables.  One is named tblCustomerAutoNotes and the other one is named tblEstimateNotes.  If any one value of fieldname in a row in tblEstimateNotes MATCHES the value of fieldname in tblCustomerAutoNotes then make the background color of that row a light green.

Possible?

Background color of a record in a datasheet view form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.