Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Continuous Forms and Conditional Formatting
Thanks for the input Aceman. Worked like a charm. Thanks, Malcolm- Malc2
- Post #6
- Forum: Microsoft: Access Forms
-
Continuous Forms and Conditional Formatting
Oh. And just to also clarify, using Join() directly in the conditional worked ok. I could hard code a value in, like: InStr(Join(query_satExclude()),"123456")>0 and that worked. same with my new function, myJoin(). It's something with the way it references the record field. I'm not doing...- Malc2
- Post #4
- Forum: Microsoft: Access Forms
-
Continuous Forms and Conditional Formatting
Join() is a VBA function. As is InStr(). I can see Join being a reserved word for SQL aspects. I wrote a wrapper for it, but it doesn't seem to work either. Public satExclude() as String Public Function query_satExclude() As Variant query_satExclude = satExclude End Function Public...- Malc2
- Post #3
- Forum: Microsoft: Access Forms
-
Continuous Forms and Conditional Formatting
Hi all, I'm using Access 2003. First, I have read many articles about using cond. formatting with continuous forms. The primary means seem to be using the Format->Conditional Formatting menu, or to create a box that will cover the background. I'm trying to use the built-in mechanism, using an...- Malc2
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
