Using <% in conditional formatting (1 Viewer)

jjake · Nov 5, 2018

Hello,

I have 2 fields in a form. [Budget] and [RemainingBudget].

I would like to use conditional formatting so that when the remaining budget falls less then 10% of the remaining budget the text will turn yellow.

How would i write this?

theDBguy · Nov 5, 2018

Hi,

How about?

(Budget-Remaining)/Budget <= 0.1

Hope it helps...

The_Doc_Man · Nov 6, 2018

Well, we can do that, but the question is WHERE do you want this to happen? And when are you likely to discover that this has happened. DBguy points out that you can do a simple computation, but your lack of further description of the "when" and "where" makes it tough to finish the job. Help us a little so we can help you.

You say it is on a form but is the form bound to an underlying table? Or what other context applies to this situation?

Cronk · Nov 6, 2018

Um, that would be
Remaining/Budget < 0.1

Doc, the form does not need to be bound.

The_Doc_Man · Nov 6, 2018

Cronk, the question is, in which event or circumstance will this condition first be recognized so that you CAN trigger a color change?

If it is bound, the solution is (perhaps) in an OnCurrent event.

If it is unbound, then WHEN does the change occur? It might be best in an OnChange or a LostFocus event, but we need a FEW more particulars.

Cronk · Nov 7, 2018

With conditional formatting, the system handles everything. There's not need to add code to any event trigger, either onCurrent or onChange.

jjake · Nov 7, 2018

Cronk said:
Um, that would be
Remaining/Budget < 0.1

Doc, the form does not need to be bound.

That did it thanks.

Using <% in conditional formatting (1 Viewer)

jjake

Registered User.

theDBguy

I’m here to help

The_Doc_Man

Immoderate Moderator

Cronk

Registered User.

The_Doc_Man

Immoderate Moderator

Cronk

Registered User.

jjake

Registered User.

Similar threads

Users who are viewing this thread