Field parameters changing for each record when displayed as contin

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to change the background colour for a particluar
record based on what is contained in a field.
At present, It changes all records displayed.
 
In design view, select all the fields you wish to be affected, then click
Format>Conditional Formatting. In the dropdown box, choose "Expression is"
and in the next box type the condition. Then select colour and font
formatting as required.
 
This seems to work for the main form, but when applied to a subform, Access
keeps crashing. It is the subform that I really want to do this with.
 
amiga1200 said:
I would like to be able to change the background colour for a particluar
record based on what is contained in a field.
At present, It changes all records displayed.
Click to expand...


Create a text box and make it the same size as the detail
section. Use the Format - Send to Back menu item to put it
behind all the other controls.

You may also want to set all the other control's BackStyle
property to Transparent.

Now you can use Format - Conditional Formatting to set the
new text box's BackColor.
 
Back
Top