Change Form colour when add new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi: Everybody

When user click the record navigation button to add a new record in a From,
I want to make the Form colour becomes light green colour.

But I don't know where to put the code into what event, thanks for help.

(Don't worry about the colour setting, I know how to do it. Just want to
know where to put the code).

Thanks.

James
 
Hi: Everybody

When user click the record navigation button to add a new record in a From,
I want to make the Form colour becomes light green colour.

But I don't know where to put the code into what event, thanks for help.

(Don't worry about the colour setting, I know how to do it. Just want to
know where to put the code).

Thanks.

James
Click to expand...

In the Form's current event:

If Me.NewRecord = true then
Me.Section(0).BackColor = vbGreen
Else
Me.Section(0).BackColor -2147483633
End If

You can add the other form sections to the above.
 
Thanks Fredg. It works.

James


fredg said:
In the Form's current event:

If Me.NewRecord = true then
Me.Section(0).BackColor = vbGreen
Else
Me.Section(0).BackColor -2147483633
End If

You can add the other form sections to the above.
Click to expand...
 
Back
Top