Coloring Certain Fields when Auditing

[Z1nkstar]

I have a database were there is a field called Item on 2 different forms and want to color the field a dark gray color when the order is audited the actual form names are below.
Form 1 - frmProduction_Schedule_ByCPO
Form 2 - frmProduction_Schedule_BySalesOrder
Field name - Item
I was thinking about putting an on click event that would color the item field so that people knew not to mess with that order.



Any suggestions are all accepted Thanks!!!

[ItsMe]

The short answer is, while in datasheet or continuous view, you cannot adjust a control's properties that will not display the same properties on another Row/Record.

Having said that, I did see someone post a solution using continuous forms and I believe some crazy programming using OLE objects. I believe it was in the MSDN forums.

[amrut]

Instead of click event I would suggest to use form's current event.
Pseudo code
If Audited =True then
code to grey out/disable controls
else
code to enable controls
endif

[John_G]

Hi -

What you need is conditional formatting on the field you want to highlight. Conditional formatting allows you to specify up to 3 different formats for a control, based on the values in that control or others (which don't have to be visible).

In your case, you would apply conditional formatting to the Item field, but you will need a data field in each record to indicate the audit status.

HTH

John

[Z1nkstar]

When the order is audited the person that audited it has to click the check box which indicates an audit status?

[Z1nkstar]

Do you know the expression I would use?

[Z1nkstar]

can you write out the directions I have found and done conditional formatting before I just don't get what you mean about a data field in each record, when the audit button is pushed a date field comes up can that be used and how would I use it if possible???

[John_G]

I don't know if that's a question or a statement, but that's what it looks like.

As long as the audit field behind the checkbox is in the order records, you can use conditional formatting.

In form design view:

- Click the "Item" field
- Click the Format tab
- Click the Conditional Formatting icon
- Click New rule
- From the dropdown on the left, select "Expression is"
- In the box to the right, enter [Audit] = True (replace Audit with your actual field name
- Set the formatting (colour, background, etc) you want to use
- Save and close the form

That is untested of course, but it should be close.

John

[Z1nkstar]

Wow Thanks Work Perfectly..!!!!

[June7]

And Access 2010 expanded from 3 to 50 conditions.