Requery & events

[Incisor]

I am trying to change the backcolor of a textbox in a continuous record form. When the value is determined to be a negative number the color should shift. This ideally would follow a requery of my form.

I can't seem to find the event that will allow testing for negative values for each record.

 

[Mile-O]

What version of Access are you using? Access 2000 and 2002 support conditional formatting in continuous forms; Access '97 doesn't.

That's as much as I know!

 

[Incisor]

Crud .... Access 97

 

[Rich]

It can be done in 97, but it's easier to use the Format property of the control to change the fore colour

 

[Incisor]

Humm ok,

Fore color or Back color either seems fine but it is the trigger mechanism after a requery that I am lacking. Any insights there?

 

[Rich]

Set the format property of the numeric control to
£#,##0.00[Black];£#,##0.00[Red], remove the currency symbol if the field's just numeric

 

[Incisor]

Very cool, thanks.

I thought all that was available was what appeared on the drop down.