more conditional formats

[icbiny]

i can do a cf with...
"Field Value is" "equal to" "[text0]"
this works fine. is it possible to do something like...

"Field Value is" "equal to" "[text0] Or equal to [text4]"
"Field Value is" "equal to" "[text0] Or [text4]"

the reason i am attmpting this is because i have 7 text boxes (all containing numbers) and cf only allows 3 seperate cf's.

i have tried coding it by building a string in a loop and then trying to convert the string into a control name, but can't seem to get my head around it as i have never used a variable for a control name before.

 

[icbiny]

solved this myself while trawling other similar probs. all I want to do is check weekly lottery numbers against our chosen lines at work. Access only allows 3 cf's while excel is limited only by memory. it took me 5 mins to set up a decent looking spreadsheet! silly me for not using excel in the 1st place I guess. if any1 can help me out with this prob anyways for future reference it would be helpful ty