Conditional Formatting on form fields

[magmike]

I am attempting to change the formatting of a form field based on the
value of a different form field. This is what I tried using the
"Expression Is" selection:

Me.Status.Value=54

However that doesn't work. Any help would be appreciated.

magmike

 

[John W. Vinson]

I am attempting to change the formatting of a form field based on the
value of a different form field. This is what I tried using the
"Expression Is" selection:

Me.Status.Value=54

However that doesn't work. Any help would be appreciated.

magmike

The Me. alias works in VBA code but not in this context; and the .Value is the
default and therefore unnecessary. Try just

[Status] = 54
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[magmike]

I am attempting to change the formatting of a form field based on the
value of a different form field. This is what I tried using the
"Expression Is" selection:

However that doesn't work. Any help would be appreciated.

magmike

The Me. alias works in VBA code but not in this context; and the .Value is the
default and therefore unnecessary. Try just

[Status] = 54
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

Thanks, that worked.

I have successfully gotten this to work on a text field sent to back
and spanning the width of the form so I don't have to set conditions
on each field and can highlight the whole "row" (I am using a
continuous form). However, I think I would like to use Datasheet view
so I can use the down arrow to go to the next record (like using
excel) but the text field box now shows at the end of the row instead
of behind the row. Is it possible to to display the text box behind
the row in datasheet view?

I know I could revert back to setting each field in datasheet view,
but the reason for the text box is that I want more than 3 conditions.
I can do this by using multiple text boxes behind the row - Otherwise
I am stuck with only three conditions.

Thanks in advance for your help

magmike