Conditional formatting not triggering

[MdHaziq]

Hello


Forum,

I am using Microsoft access 2016.

I set conditional formatting for my form, [Froms]![frmMaster] and report, rptMaster but no results visible when applied.

The rule I wanted to set was Expression: [CurrentQty]<=[tblMaster1]![BaseQty]

for both frmMaster and rptMaster.

Any help will be much appreciated.

TIA

Haziq

[Bob Fitz]

Add the field called "BaseQty" to the forms query.

Change the expression used in conditional formatting to:
Value <= [BaseQty]

See Attached file:

[MdHaziq]

Dear,
Bob

I really don't know how to thank you already.

You have been a great help.

Thanks a million.

Haziq