Continuous lists in a form

A

amiga1200

I have a list of companies, what I would like to do is have alternating
colours & have the entire record change colour when selected, also I do not
want the cursor the appear in any of the fields.

Thanks
 
R

Roger Carlson

On my website (www.rogersaccesslibrary.com), there are two small Access
databases samples which illustrates might help. For the alternating colors,
look for the sample called "Greenbar.mdb". For changing the color of the
selected record, see "ConditionalFormatting.mdb" (Continuous Form 4). I
don't have a sample to prevent the cursor from appearing, but try playing
around with the Locked and Enabled properties.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
S

Stephen Lebans

Roger there is a bug in CF whereby the Enabled property is not respected
when you setup CF via its GUI. The workaround is to modify the
FormatConditions object directly usually in the Form's Load event. There
is sample code on my site.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
D

Douglas J. Steele

Try again. Clicking on the hyperlink you posted worked for me 5 seconds ago.
 
Top