Highlight NEW record in continuous form entry

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a form with subforms all data is somwhat greyed out to indicate
they are not editable. The subfoms are continuous forms with
allowadditions to No unless a command button is clicked. On the click
of the button I would like to highlight the controls in this new
record.

I have done a lot of searching but only found methods of highlighting
the current record.

Any ideas?

Dave
 
Assuming you have an AutoNumber field named ID, place a text box behind the
others in your subform. Set its Conditional Formatting to:
Expression ... [ID] Is Null
and choose a suitable color.
 
Back
Top