02-21-2007, 07:23 AM #3 miguel vasquez Registered User http://pentagramweb.com/solved-changing/solved-changing-query.html I recognise Quality when I hear it Ron_dK View Public Profile Find More Posts by Ron_dK « Previous Thread | Next Thread » Thread Tools In Access 2000 and later, you can use Conditional Formatting instead. -- Allen Browne - Microsoft MVP. Join & Ask a Question Advertise Here Enjoyed your answer?

You may have to register before you can post: click the register link above to proceed. Set the tab control to transparent. It may be named [txtCurrentRecord] and I will set its Control Source to =IIf([EE_SelectedNote]=[txtCurrentRecord],String(45,"g"),"") (I do not understand the string with 45 g and its fontname and size as well as check over here Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2017 XenForo Ltd.

And make sure that this is behind all your other textboxes. 0 Message Author Comment by:jirdeaid ID: 381269452012-06-26 Nope... Yes, my password is: Forgot your password? It is only for one field and depends solely on the On Current event to highlight the record - which it does. .

Reply to group, rather than allenbrowne at mvps dot org. "Downie" <> wrote in message news:... >I am using Access 2002 - 2003. > I switched from datasheet to continous form

The selected record is PERFECT. And I strongly suspect that it won't work - the situation is that, when there are no selected records ms/access 2010 entirely greys out the record. More About Us... Covered by US Patent.

Single-word antonym for "cheapest"? Solution Suppose you want to display in green the amounts above 100 dollars. It's quick & easy. this content Browse other questions tagged ms-access forms or ask your own question.

Not the answer you're looking for? Answer: This can be accomplished with Conditional Formatting. The purpose of this eBook is to educate the reader about ransomware attacks. Set the the Style property to None for the tab control and the use any other control that has a click event to create your own colourful tabs (you can even

Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Reply to group, rather than allenbrowne at mvps dot org. "Downie" <> wrote in message news:... > Ok, I've been at this for a few hours now. > > I can't As a matter of face, attempting to change the settings programmatically will probably not do what you expect: the settings will be changed for all visible records, not only the current Basically, the color of the tabs can be controlled using the Pressed Color property.

Select the control you want to change color Choose Conditional Formatting from the Format menu. Select "Conditional Formatting" from the popup menu. Having seen your screen captures, I was able to create the desired design in a few seconds, literally. If you want it to be an entirely different colour, you might have to add a rectangle to the form (make the background non-transparent), maximise it within the tab and then

Similar topics how to change back color of selected tree node when fullrowselect property is true Change Font color of text string.