textbox backcolor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wachs - 23 Jun 2007 23:29 GMT

I am trying to set the backcolor of a textbox in Continuous Forms view
uniquely for each record displayed on the form. When I set the color in
OnCurrent Event Handler, the color changes for that field for all records on
the display. How can I change each record individually?

Reply to this Message

John W. Vinson - 24 Jun 2007 00:40 GMT

>I am trying to set the backcolor of a textbox in Continuous Forms view
>uniquely for each record displayed on the form. When I set the color in
>OnCurrent Event Handler, the color changes for that field for all records on
>the display. How can I change each record individually?

With Conditional Formatting: open the form in design view, select the textbox,
and choose Conditional Formatting from the Format menu option.

This only works in A2000 or later.

John W. Vinson [MVP]

Reply to this Message