Continuous Form with Different Row Highlighting

  • Thread starter Thread starter sneuf via AccessMonster.com
  • Start date Start date
S

sneuf via AccessMonster.com

Hi,
I have a form in Continuous view. Each row has several columns. I want to
highlight one row based on what is in one column of that row. Can that be
done? Here is a simple example of what I mean:

row1: abc test1
row3: def test2
row2: ghi test3

Can I highlight only the row that has test2 in that column?

Thanks!
Steve
 
sneuf said:
I have a form in Continuous view. Each row has several columns. I want to
highlight one row based on what is in one column of that row. Can that be
done? Here is a simple example of what I mean:

row1: abc test1
row3: def test2
row2: ghi test3

Can I highlight only the row that has test2 in that column?
Click to expand...


To highlight an entire row/record, add a text box and use
Conditional Formatting (Format menu item). Set the
Expression Is: option to something like:
[testtextbox] = "test2"
and select the desired BackColor.

Then use Send To Back (Format menu) to move it behind all
the other controls.

You will probably also want to set the other controls'
BackStyle to Transparent.
 
Will this work if I don't know exactly which row/record will contain the text
that I want to highlight?
Thanks!
Steve

Marshall said:
I have a form in Continuous view. Each row has several columns. I want to
highlight one row based on what is in one column of that row. Can that be
Click to expand...
[quoted text clipped - 5 lines]
Can I highlight only the row that has test2 in that column?
Click to expand...

To highlight an entire row/record, add a text box and use
Conditional Formatting (Format menu item). Set the
Expression Is: option to something like:
[testtextbox] = "test2"
and select the desired BackColor.

Then use Send To Back (Format menu) to move it behind all
the other controls.

You will probably also want to set the other controls'
BackStyle to Transparent.
Click to expand...
 
This works great!! Thanks Marsh!
Will this work if I don't know exactly which row/record will contain the text
that I want to highlight?
Thanks!
Steve
[quoted text clipped - 13 lines]
You will probably also want to set the other controls'
BackStyle to Transparent.
Click to expand...
Click to expand...
 
You must have figured this out already, but for
completeness, I should have mentioned that the highlighting
text box should be positioned and sized to fill the entire
detail section before using Send To Back.
--
Marsh
MVP [MS Access]

This works great!! Thanks Marsh!
Will this work if I don't know exactly which row/record will contain the text
that I want to highlight?
Thanks!
Steve
I have a form in Continuous view. Each row has several columns. I want to
highlight one row based on what is in one column of that row. Can that be
Click to expand...
[quoted text clipped - 13 lines]
You will probably also want to set the other controls'
BackStyle to Transparent.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top