Conditional formatting "Bre-x" <mamani[ at ]home.com> 10/24/2008 3:35:47 PM On a Datasheet Form, can you "Conditional Format" and entiry record? (make the row "Yellow" per example) Thank you all Bre-x

Re: Conditional formatting fredg <fgutkind[ at ]example.invalid> 10/24/2008 5:19:09 PM On Fri, 24 Oct 2008 09:35:47 -0600, Bre-x wrote: [Quoted Text] > On a Datasheet Form, can you "Conditional Format" and entiry record? (make > the row "Yellow" per example) > > Thank you all > > Bre-x Make the row yellow when? What is the criteria to make the row yellow? Let's assume you wish to color the row if the Record's [CompanyName] field is for "Jones Co." Open the form in Design View. Click on the control that will display the company name. Click on Format + Conditional Formatting Set Condition1 to: Value is in the next box select equal In the next box write: "Jones Co." Select the Yellow color. Click OK Next, select each of the other controls of that record. Click on Format + Conditional Formatting Set Condition1 to Expression Is In the next box write [CompanyName] = "Jones Co." Select the color. Click OK. Make sure the BackStyle property for each control is set to Normal. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail

Re: Conditional formatting "Bre-x" <mamani[ at ]home.com> 10/24/2008 6:03:30 PM Thank you It works very well "fredg" <fgutkind[ at ]example.invalid> wrote in message news:pgru6z1zdd2m$.13h0zscicxigi.dlg[ at ]40tude.net... [Quoted Text] > On Fri, 24 Oct 2008 09:35:47 -0600, Bre-x wrote: > >> On a Datasheet Form, can you "Conditional Format" and entiry record? >> (make >> the row "Yellow" per example) >> >> Thank you all >> >> Bre-x > > Make the row yellow when? > What is the criteria to make the row yellow? > > Let's assume you wish to color the row if the Record's [CompanyName] > field is for "Jones Co." > > Open the form in Design View. > Click on the control that will display the company name. > Click on Format + Conditional Formatting > Set Condition1 to: > Value is > in the next box select > equal > In the next box write: > "Jones Co." > Select the Yellow color. > Click OK > > Next, select each of the other controls of that record. > Click on Format + Conditional Formatting > Set Condition1 to > Expression Is > In the next box write > [CompanyName] = "Jones Co." > Select the color. > Click OK. > > Make sure the BackStyle property for each control is set to Normal. > -- > Fred > Please respond only to this newsgroup. > I do not reply to personal e-mail

RE: Conditional formatting Ken Sheridan 10/25/2008 10:57:00 PM You might also be interested in the thread at: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access&mid=a338e9dd-9a47-4ce8-8092-5e2bb6284284 for doing it in a report. Ken Sheridan Stafford, England "Bre-x" wrote: [Quoted Text] > On a Datasheet Form, can you "Conditional Format" and entiry record? (make > the row "Yellow" per example) > > > Thank you all > > Bre-x > > >

RE: Conditional formatting Mishanya 12/25/2008 10:58:01 PM Hi Ken! Excuse me for addressing you with no relation to this thread. 3 days ago I've posted a question with subject "Modifying Delete Button code". Since then I kept on getting e-mails by notifyMS[ at ]microsoft.com that the post was answered, but whenever I open the Office Discussion page "New users", where I posted the question, I get the list where my post is the last one - and unanswered! As if no posts were added since 23/12/08. Moreover, when I try to post anything - it does nor appear. I had to google on the name of my post, to find it in the www.tech-archive.net and to find out, that it was answered by you and a few other guys. So I searched on Your name in the Office Discussion page and got to this tread - which was started on 24/12/08 - misteriously I can not see it in the normal page view (only thru the search). So, firstly, thank You for Your reply. Secondly - do You have any idea what is happening with me blocked from seeing any posts in the Office Discuccion pages (any of them) posted later then my last post? DO you see any, or You get to the posts thru www.tech-archive.net? "Ken Sheridan" wrote: [Quoted Text] > You might also be interested in the thread at: > > > http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access&mid=a338e9dd-9a47-4ce8-8092-5e2bb6284284 > > > for doing it in a report. > > Ken Sheridan > Stafford, England > > "Bre-x" wrote: > > > On a Datasheet Form, can you "Conditional Format" and entiry record? (make > > the row "Yellow" per example) > > > > > > Thank you all > > > > Bre-x > > > > > > >

Re: Conditional formatting "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 12/26/2008 1:36:07 PM I understand that there are some problems with Microsoft's web interface at the moment. That's one of the reasons why so many of us prefer to use a newsgroup reader, pointed to msnews.microsoft.com. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Mishanya" <Mishanya[ at ]discussions.microsoft.com> wrote in message news:0AC1DBB7-4A8B-42C3-845B-79612E6DE577[ at ]microsoft.com... [Quoted Text] > Hi Ken! > Excuse me for addressing you with no relation to this thread. > 3 days ago I've posted a question with subject "Modifying Delete Button > code". Since then I kept on getting e-mails by notifyMS[ at ]microsoft.com that > the post was answered, but whenever I open the Office Discussion page "New > users", where I posted the question, I get the list where my post is the > last > one - and unanswered! As if no posts were added since 23/12/08. Moreover, > when I try to post anything - it does nor appear. > I had to google on the name of my post, to find it in the > www.tech-archive.net and to find out, that it was answered by you and a > few > other guys. > So I searched on Your name in the Office Discussion page and got to this > tread - which was started on 24/12/08 - misteriously I can not see it in > the > normal page view (only thru the search). > So, firstly, thank You for Your reply. > Secondly - do You have any idea what is happening with me blocked from > seeing any posts in the Office Discuccion pages (any of them) posted later > then my last post? DO you see any, or You get to the posts thru > www.tech-archive.net? > > "Ken Sheridan" wrote: > >> You might also be interested in the thread at: >> >> >> http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access&mid=a338e9dd-9a47-4ce8-8092-5e2bb6284284 >> >> >> for doing it in a report. >> >> Ken Sheridan >> Stafford, England >> >> "Bre-x" wrote: >> >> > On a Datasheet Form, can you "Conditional Format" and entiry record? >> > (make >> > the row "Yellow" per example) >> > >> > >> > Thank you all >> > >> > Bre-x >> > >> > >> > >>