(3rd post) conditional formatting, tabular textbox

  • Thread starter Thread starter drabbacs
  • Start date Start date
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
..
 
Use the recordsetclone object of your form to go to the record before the
current one and access the value this way. Access is a completely different
program than Excel and problems will need to be solved in a completely
different way.
 
I am aware that excel and access are diffeent programs and
therefore will need different solutions. That's why I
posted the question. I was trying to indicate that I know
how to do conditional formatting but that I don't know how
to reference the line above in a tabular-format textbox.

Regarding recordsetclone. There is no information in help
for VBA or for Access about recordsetclone. The recordset
property of my form is set to dynaset meaning it will
allow edits.

Are you refering to the clone method? If so are you
suggesting code that would clone the recordset then loop
through the entries doing comparisons between the original
and the clone with the clone's pointer being one less than
the original and then modifying the textbox associated
with the original?

Drabbacs
 
Back
Top