Quasi condition formatting with background color

[Perceptus]

Is there a way to change the background color of an object on a continuous form? I would like to have the back color of the form change per the data that is in a bound field.

Thanks

[June7]

You want to change the backcolor of form Detail section?

Use code. I expect VBA can do it, like:

Me.Detail0.Backcolor = vbred

[Perceptus]

This works, but it sets the back color for all the forms in continuous form. I am looking to achieve similar to conditional formatting in excel, for record background color.

Only thing I could think of currently would be to load a BITMAP and have it be set to the back of the form. then have different bitmaps for each color.

[June7]

There isn't any 'record background' except for the AlternateBackColor property of Detail section and this cannot be effectively programmed conditionally in Continuous or Datasheet view. Have to use Conditional formatting for each control.

[Perceptus]

Alright, I will check that out

[Micron]

It sounds like you want conditional formatting for record rows. If so, the alternate row colour will not be what you want. How about a textbox control that spans the width of your form (or just the controls you want to highlight) that is positioned behind the data controls, whose properties you set in code depending on the condition? I have done something like this to show the logged in user control as yellow, just not for an entire row. You could play with the properties of the control as well (raised, sunken, bordered) to present some unique effects.

[Missinglinq]

Micron's suggestion is the standard workaround for this kind of thing. You'll have to add a Field to your underlying Table to use as the Control Source for the Textbox, of course, otherwise, once again, the Control on all Records would be formatted as the Current Record dictates.

Once the Textbox has been created, you'll need set it Locked Property to Yes and Enabled Property to No; this is necessary to keep the cursor from tabbing into the Textbox.

In a Single View Form you could use code to set the Formatting, but in a Continuous View Form you'll then need to use Conditional Formatting, off the Ribbon, to set the Conditions/Back Colors as you want, probably using the Expression Is under the Condition dropdown.

Linq ;0)>

[June7]

Actually, the control does not have to be bound to a field. Just tested.

The Conditional Formatting for all records is NOT dictated by the current record - that's the whole point of Conditional Formatting.

[Missinglinq]

You're right, of course...need to adjust my medication!

Linq ;0)>