If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formatting in continuous form
I read an earlier post regarding conditional formatting of rows of a
form in continuous mode. The post contained a link to Leban's site which had an example database. http://www.lebans.com/conditionalformatting.htm I took a look at it and it has what I need but I can't understand how he made it work. There is no code in any of the form/control events (related to formatting the row). The database contains a couple of classes and 2 modules but I can't see how they are linked into the form. Can someone please tell me how the classes are being implemented or the module being called without code on the forms? Thanks Alan |
#2
|
|||
|
|||
Which sample form are you trying to implement in your own MDB?
In form Design view select one of the TextBox controls that has CF applied to it. Go to the Format menu and select COnditionalFormatting. "Expression is" probably contains the name of a function that is called to evaluate each row as it is displayed. -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "Alan" wrote in message ... I read an earlier post regarding conditional formatting of rows of a form in continuous mode. The post contained a link to Leban's site which had an example database. http://www.lebans.com/conditionalformatting.htm I took a look at it and it has what I need but I can't understand how he made it work. There is no code in any of the form/control events (related to formatting the row). The database contains a couple of classes and 2 modules but I can't see how they are linked into the form. Can someone please tell me how the classes are being implemented or the module being called without code on the forms? Thanks Alan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Apply Conditional Formatting to Consecutive Records w/ Same Value | Tom | Using Forms | 2 | September 24th, 2004 02:16 PM |
Default values to load up automatically in a form based on value entered in another form | Anthony Dowd | Using Forms | 8 | August 12th, 2004 08:53 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
MIN value exclude '0' & Conditional Formatting | JEM | Worksheet Functions | 5 | April 16th, 2004 03:40 AM |