Hi folks
I have a continuous form with 8 text fields on (all in a row). I am trying to get it so that if one of the fields contains the word 'Visit', then the whole row turns a different colour... but only that one row that includes that word. I am guessing I will just have to change the 'detail section' as the controls are individual. I have been playing around with the conditional formatting and can get it to work perfectly for the individual field but not the whole row (i.e. detail), I have tried the following but no joy.... any tips???
IIf([ActionType]="Visit",Detail.BackColor=*****)
* I'm not sure which number I am meant to put here; I tried putting #000080 (the type of blue I want) but it kept telling me there was an incorrect date... I took the has out and it just didnt work anyway??
I have a continuous form with 8 text fields on (all in a row). I am trying to get it so that if one of the fields contains the word 'Visit', then the whole row turns a different colour... but only that one row that includes that word. I am guessing I will just have to change the 'detail section' as the controls are individual. I have been playing around with the conditional formatting and can get it to work perfectly for the individual field but not the whole row (i.e. detail), I have tried the following but no joy.... any tips???
IIf([ActionType]="Visit",Detail.BackColor=*****)
* I'm not sure which number I am meant to put here; I tried putting #000080 (the type of blue I want) but it kept telling me there was an incorrect date... I took the has out and it just didnt work anyway??
