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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Background Colours in a Continous Form 3
Conditional Formating for each Record 1
Duplicate a Record 7
Continous Form 2
Check fields when user changes tabs 3
Create "Copy previous record" on a continous form 5
For Each Record 4

Back
Top