How to color a row ?

[Guest]

Dear all,
I have more than 1000 rows in a database sheet, I like to color the rows
(not all the rows) - is there any way color the raws in between? when I click
"Fill/Back color" it applies to entire the sheet. (in Excel we can color the
row whichever we like)
Please help

 

[Jeff Boyce]

Shan

It isn't clear where you are trying to do this. Your reference to Excel
suggests you are trying to do this in a table. If so, be aware that Access
tables only store data, and have a very limited range of display
capabilities. Access forms display data, and provide a very rich event
environment.

Access isn't a spreadsheet.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Shan

It is possible to display 1000 rows of data in different colours on a form
using a Flex Grid control, it rather depends on what you want to do. If you
send me an e-mail I can send you a sample database which demonstrate the
techniques. You will need to write some VBA code however. See the profile for
my e-mail address (omit the last part of the address, of course).

 

[Larry Daugherty]

There are plenty of freely downloadable sample applications along
those lines at www.lebans.com

HTH