Highlight NEW record in continuous form entry

[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

 

[Allen Browne]

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.