Loop through Details section in access report

[shod90]

Dear Gents,


Is there a way to loop through access report details section ? .. I need to do the following:
1- Loop through Details section for all items.
2- Check if the sell price is smaller than buy price then change the forecolor to red for this record only.
3- Continue looping and check if the sell price is larger than sell price then make the forecolor to black again.

something like.

------------------------------------------------------
|Order No | Date | Buy price | Sell Price|
------------------------------------------------------
|1 | 7/4/2017| 20 | 18 |
-------------------------------------------------------
|2 | 7/4/2017| 20 | 22 |
-------------------------------------------------------
|3 | 7/4/2017| 20 | 18 |
-------------------------------------------------------
|4 | 7/4/2017| 20 | 18 |
-------------------------------------------------------

[ranman256]

In the detail ON PRINT event,

if txtSell < txtBuy then
   TxtNum.forecolor = vbRed
else
  TxtNum.forecolor = vbBlack
endif

[CJ_London]

you will need to use conditional formatting rather than looping through the detail controls

it would be something like

expression is....[Sell Price]<[Buy Price]

then set the forecolor to red

[HiTechCoach]

Dear Gents,
Is there a way to loop through access report details section ?

Access report ready have a built in method to handle this.

There are events that fire as the report process the records. Yiou can add VBA code to eh events to do what yu need.

.. I need to do the following:
1- Loop through Details section for all items.
2- Check if the sell price is smaller than buy price then change the forecolor to red for this record only.
3- Continue looping and check if the sell price is larger than sell price then make the forecolor to black again.

Thre are two ways to handle what you need:

1) Use Conditional formatiung. See previous reply Ajax

2) use VBA code in an event. In yur case the try the On Format or On Print events. See previous reply by ranman256


I prefer to use Conditinal formtating when possible. Note: Conditional formatting works great on forms too