D
drabbacs
I have a form which displays tabular-formatted information
in a textbox. I want to change the backcolor based on the
comparison of one entry to the entry above it.
For example: Let's say I have a field called 'orders'.
When the form is opened, the textbox for 'orders' has 4
lines. If line4 > 2* line3 then turn line4 green.
In Excel this would be done by saying if 'cell value' 'is
greater than' 2* (name of the cell above) then green. What
I don't know how to do in Access is specify the name of
the line/entry above.
Any help is greatly appreciated.
Drabbacs
in a textbox. I want to change the backcolor based on the
comparison of one entry to the entry above it.
For example: Let's say I have a field called 'orders'.
When the form is opened, the textbox for 'orders' has 4
lines. If line4 > 2* line3 then turn line4 green.
In Excel this would be done by saying if 'cell value' 'is
greater than' 2* (name of the cell above) then green. What
I don't know how to do in Access is specify the name of
the line/entry above.
Any help is greatly appreciated.
Drabbacs