Dan Waters
dwaters at usinternet.com
Mon Aug 13 15:34:27 CDT 2007
Hi Thomas, How about using Conditional Formatting? For each control in your continuous form, set conditional formatting to change the background color if say, [RecordID] = 5 Or [RecordID] = 8. You could also have different colors for row 5 and for row 8. HTH! Dan Waters -----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 10: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