conditional format

[Ian]

I have several textboxes on a form that have dsum's as their control sources.
I'd like to set the background of one of them [diff] to show red if the
vaule <>0 but I can' find the conditional format anywhere on the format menu.
I've turned off enable and locked it. any ideas -- i've never used this
before so may be looking in the wrong place.

thx

 

[Daniel]

Ian,

Take a look at

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000011#chgBkgrndColor

For a code example

Daniel

 

[Ian]

sorry -- i just needed to change the textbox not the for section. can i
apply the same code to the textbox with an If [diff]<> 0 Then .....
Where should I put the code though? In the OnCurrent of the form or an
event in the box?

Thanks.

Ian,

Take a look at

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000011#chgBkgrndColor

For a code example

Daniel

I have several textboxes on a form that have dsum's as their control sources.
I'd like to set the background of one of them [diff] to show red if the
vaule <>0 but I can' find the conditional format anywhere on the format menu.
I've turned off enable and locked it. any ideas -- i've never used this
before so may be looking in the wrong place.

thx

 

[Jeff Boyce]

Ian

What happens if your form is in design view, you highlight the control, and
click on Format in the menu? In my copy of Access, I see, among other
choices, Conditional Formatting.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Daniel]

Ian,

Jeff's approach is simplest if you only have 3-4 rules max to apply (which
seems to be your case). Does the Conditionnal Formatting option appear when
you open your form in design view and select the control and then go
Tools-Conditional Formatting?

Daniel

sorry -- i just needed to change the textbox not the for section. can i
apply the same code to the textbox with an If [diff]<> 0 Then .....
Where should I put the code though? In the OnCurrent of the form or an
event in the box?

Thanks.

Ian,

Take a look at

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000011#chgBkgrndColor

For a code example

Daniel

I have several textboxes on a form that have dsum's as their control sources.
I'd like to set the background of one of them [diff] to show red if the
vaule <>0 but I can' find the conditional format anywhere on the format menu.
I've turned off enable and locked it. any ideas -- i've never used this
before so may be looking in the wrong place.

thx

 

[Ian]

OK -- it's official that I'm a moron. I was spending all that time looking
thru the properties menu/format rather than just right clicking on the thing.
Thanks guys.

Ian,

Jeff's approach is simplest if you only have 3-4 rules max to apply (which
seems to be your case). Does the Conditionnal Formatting option appear when
you open your form in design view and select the control and then go
Tools-Conditional Formatting?

Daniel

sorry -- i just needed to change the textbox not the for section. can i
apply the same code to the textbox with an If [diff]<> 0 Then .....
Where should I put the code though? In the OnCurrent of the form or an
event in the box?

Thanks.

Ian,

Take a look at

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000011#chgBkgrndColor

For a code example

Daniel




:

I have several textboxes on a form that have dsum's as their control sources.
I'd like to set the background of one of them [diff] to show red if the
vaule <>0 but I can' find the conditional format anywhere on the format menu.
I've turned off enable and locked it. any ideas -- i've never used this
before so may be looking in the wrong place.

thx