Colored Highlight Bar

[StayNuts]

Busy to create a form with a list of the records in my database. Using for that a continue form ( hope is the right English term, use a local language version of Access )... Put on the details section a text field with the title of the record. When I run the form, I get a nice list with all the text fields in a row. Very standard access stuff... lol When I click on that text field, a new window appears on the screen and I can edit the record, that all works, no problems.

My question goes about how to create a bar which highlight the entire row of the current selected record. For ex.

TANGO PROP $100.-
VICTOR JET $200.-
YANKEE JET $225.-
ZULU JET $200.-

now only the first word ( in the ex. YANKEE ) is showing as selected, my wish is to do it with the entire row...

Second question, can I also change the background color of the details section for each row different. For ex. odd rows blue and even rows black

thx

 

[dgkindy]

Make the textbox that contains the text transpartent and place another box behind it. Then use us VB code to change the colour of the txtboxes in back. You can then highlight the entire row.

 

[StayNuts]

Make the textbox that contains the text transpartent and place another box behind it. Then use us VB code to change the colour of the txtboxes in back. You can then highlight the entire row.

don't work, on the moment that the front field is in focus, it will indeed change the color of the background textbox... but it will happens on the entire list...

other option to make the txtbox on the back the selection bar and using conditional formating... also don't work... the txtbox on the background will get focus and cover the front locked txt fields...

 

[boblarson]

Check this out for highlighting alternating rows:

http://www.mvps.org/access/forms/frm0047.htm

Also, to highlight an entire row, size the controls so that they are all touching an then use conditional formatting (you have to set it on each control) to highlight to a specific color when certain criteria are met (use the EXPRESSION IS part of the conditional formatting). (that will only work for bound controls)