Conditional Formatting on Current

S

Steven

I would like the current record in a dtasheet form to have conditional
formatting, not on focus because that requires the initial clicking on the
field. What expression can I use in the conditional formatting dialog box to
make this happen? Thanks
 
M

Marshall Barton

Steven said:
I would like the current record in a dtasheet form to have conditional
formatting, not on focus because that requires the initial clicking on the
field. What expression can I use in the conditional formatting dialog box to
make this happen?
Click to expand...


Add a text box named txtCurrent to the form's header
section/ If you don't have a header section, use the View
menu to create it (it won't display on a datasheet form).

Now use the Form's Current to set the text box's value to
the record's primary key field:
Me.txtCurrent = Me.pkfield

With that takeb care of, you can use Conditional Formatting
expressionL
[pkfield] = [txtCurrent]
 
Top