Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 17th, 2007, 03:52 AM
Registered User
 
Join Date: Jul 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Colouring first record of report [Solved]

Hello,
It is been I while I haven't come here ! Anyway, here is what I am looking for :
I have created a directory list report of people by categories.
In every category, there is a manager (check boxed) and as is, every manager wants to appear in bold.
So, how can I make every manager by category appearing in bold ?
Already thankful for your answers,
Regards,
Sven
 
Old July 18th, 2007, 06:44 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   I can't tell if this is solved or not. Are you displaying this information in a form or report?

If in a form, in the Form's On Current event, put this:

If Me.chManagerCheckBox = True Then
   Me.ManagersName.FontBold = True
Else
   Me.ManagersName.FontBold = False
End If

You can do the same for a report, just put it in the Detail section's On Format event.

Did that help?


mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
SOLVED - VBA Help For Row Source and Record Source eusanpe Access VBA 4 May 13th, 2008 11:58 AM
Bolding some record of report [Solved] Svenzardda Access VBA 4 July 18th, 2007 08:04 AM
Syntax Error -- BUG REPORT Solved dparsons MySQL 1 October 5th, 2006 01:38 PM
cell colouring EXCEL crmpicco Excel VBA 2 April 20th, 2005 11:14 AM
Colouring records Tachyophan Access VBA 8 March 29th, 2005 09:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.