Where is the code

[baka77]

I have an Access file with query, forms, tables which I did not create and I am trying to understand how it works.

In one of the form, I have some combo boxes and some text boxes.
The combo boxes contains three values 0, 1 , 2
Depending on the value selected in the combo box, the text color in the text box change .


I am looking for the code doing this.

I have checked the combo box event via the design mode but all the events are empty.
I also checked via Visual Basic editor but it is almost empty, there was no function which change the text box color.

Unfortunately I cannot attach any files, if you have any clue please post an answer.

Thank you very much in advance.

[R_Badger]

That sounds like conditional formatting

Also if you want to understand how it works I suggest reading:

For normalisation http://www.barrywise.com/2008/01/dat...gn-techniques/

For SQL http://www.w3schools.com/sql/default.asp

Knowing those two things should help you understand how the data works, but the above should solve your more immediate issue.

[June7]

And for conditional formatting review http://office.microsoft.com/en-us/ac...010208133.aspx

[R_Badger]

Thanks June, typical me lately! links to everything bar what the question was actually about! (and to add to it I posted this against the wrong thread a minute ago, that'll teach me to have this open on two computers at once!

[baka77]

Thank you very much, you are right.
It was conditional formatting, I did not know about this feature in Access.
It was a real mystery until now