B
Boots
Hi,
I am trying to create a loop to help format a report. On the report I
have 52 fields named TimeSeg1.....to......TimeSeg52.
My loop has to format each Field into a certain colour depending on its
value. I have created a Do While loop with the theory that I can use the
following
--------------------------------------------------------------------------------------
dim ts as ? (i have tried string, control and field)
dim lp as integer
lp = 1
ts = ("Me.TimeSeg" & lp)
Do while (lp < 53)
LOOP CRITERIA to format field
lp = lp +1
loo
I am trying to create a loop to help format a report. On the report I
have 52 fields named TimeSeg1.....to......TimeSeg52.
My loop has to format each Field into a certain colour depending on its
value. I have created a Do While loop with the theory that I can use the
following
--------------------------------------------------------------------------------------
dim ts as ? (i have tried string, control and field)
dim lp as integer
lp = 1
ts = ("Me.TimeSeg" & lp)
Do while (lp < 53)
LOOP CRITERIA to format field
lp = lp +1
loo