[AccessD] Highlighting a record in a form

Can you add a sequence number to the table you make with the query and use
conditional formatting in the form to change the background color of the
bound text boxes if the sequence number = 5 or the sequence number = 8?

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ewaldt at gdls.com
Sent: Monday, August 13, 2007 8:18 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Highlighting a record in a form

I'd prefer to do this in datasheet view, but I can use continuous form with
the fields shown horizontally.

Is there a way to simply tell Access to highlight the 5th record? Not every
fifth record (although that would be okay, since there are only 8); just the
fifth. The data comes from a table I create via a make table query, so I can
control exactly what goes where. I need records 5 & 8 highlighted n the
form. That's all. Seems easy, but I can't seem to get it. Feel free to make
me feel even more stupid by suggesting an easy solution.

TIA.

Thomas F. Ewald
Stryker Mass Properties
General Dynamics Land Systems


This is an e-mail from General Dynamics Land Systems. It is for the intended
recipient only and may contain confidential and privileged information.  No
one else may read, print, store, copy, forward or act in reliance on it or
its attachments.  If you are not the intended recipient, please return this
message to the sender and delete the message and any attachments from your
computer. Your cooperation is appreciated.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.15/949 - Release Date: 8/12/2007
11:03 AM