A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Conditional formatting in continuous form



 
 
Thread Tools Display Modes
  #1  
Old October 5th, 2004, 03:02 PM
Alan
external usenet poster
 
Posts: n/a
Default 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  
Old October 6th, 2004, 01:20 AM
Stephen Lebans
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.