Conditional Formatting on Current

[Guest]

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

 

[Marshall Barton]

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?

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]