Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Row Banding and Visual Attributes

Richard HarrisonDec 22 2025

Hi

I am using the Row Banding feature on a few data blocks since I have migrated to Forms 14.1.2.

This works well apart from when I have a form that contains this in a POST-QUERY trigger:

IF :block1.text1 = ‘1’ THEN

SET_ITEM_INSTANCE_PROPERTY('block1.text1',CURRENT_RECORD, VISUAL_ATTRIBUTE,'VA_RED_BACKGROUND')

END IF;

Any visual attributes where the background colour is defined are ignored / overwritten by the row banding.

If the foreground colour is defined in the VA then this is still applied.

Is there another way of achieving this, or do I just disable the row banding on the columns that may have a background colour VA applied?

Thanks in advance.

Regards

Richard

Comments
Post Details
Added on Dec 22 2025
8 comments
153 views