Hello,
I was wondering if someone might be able to shed some light on this. I have created a continuous form in Microsoft Access 2000 that displays data from two models side by side. I would like to show in each record discrepancies between data that is in each model by highlighting the offending bits of data. So far I have been forced to use Microsofts conditional formatting functionality however this is very time consuming to set-up on the amount of data I am using. My question therefore is: is there anyway in VBA in which you can reference individual instances of a field within a continuous form i.e. if I have a continous form that displays 10 records each containing 1 field, is there any way I can reference the 6th, 9th etc occurance of this field. My attempts so far have been a complete disaster. Am I missing something? Please help!
I was wondering if someone might be able to shed some light on this. I have created a continuous form in Microsoft Access 2000 that displays data from two models side by side. I would like to show in each record discrepancies between data that is in each model by highlighting the offending bits of data. So far I have been forced to use Microsofts conditional formatting functionality however this is very time consuming to set-up on the amount of data I am using. My question therefore is: is there anyway in VBA in which you can reference individual instances of a field within a continuous form i.e. if I have a continous form that displays 10 records each containing 1 field, is there any way I can reference the 6th, 9th etc occurance of this field. My attempts so far have been a complete disaster. Am I missing something? Please help!
