>I took Stephen's CustomerInContinuousView form and added three new text
>boxes. I left the record source the same and tested the form. It worked as
[quoted text clipped - 7 lines]
>think I've got it down to a very simple test. The question is...what have I
>missed?
Take a look at the Conditional Formatting properties window
(Format menu) for the text boxes. It probaly has an
expression that refers to the text boxes that are now
displaying #Name, so the CF condition can not be evaluated
properly.

Signature
Marsh
MVP [MS Access]
rick a - 16 May 2005 13:30 GMT
Marsh,
There must be some secret to Stephen's form and conditional formatting that
I just do not understand.
When I copy Stephen's form and change the control names to fields in my
recordsource everything seems to work. Oh, I did modify code in his
conditional formatting class to recognize the new form name.
However, when I create a brand new form, put all the exact same fields and
recordsource on it, and try to make it work it does not.
Do you know what the secret is? I cannot find it. I've made my new form
work but I'd like to extend this to other already created forms but I just
don't know what to add or configure to make it work.
Thanks,
--
Rick Allison
> >I took Stephen's CustomerInContinuousView form and added three new text
> >boxes. I left the record source the same and tested the form. It worked as
[quoted text clipped - 17 lines]
> Marsh
> MVP [MS Access]
Marshall Barton - 16 May 2005 22:31 GMT
>There must be some secret to Stephen's form and conditional formatting that
>I just do not understand.
[quoted text clipped - 9 lines]
>work but I'd like to extend this to other already created forms but I just
>don't know what to add or configure to make it work.
AFAIK, there is no "secret", it's just a matter of getting
all the details straightened out.
I do want to mention that you seem to be confusing the words
FIeld and Control, A field is a column in a table/query,
while a control is an object on a form/report that is used
to display values. The name of a control has nothing to do
with the name of a field, except in some cases where they
must be different.

Signature
Marsh
MVP [MS Access]
rick a - 16 May 2005 17:46 GMT
Marsh,
What's the difference between "Bring to Front" and "Send to Back"? Can
these be controlled programmatically?
I ask because when I take the textbox that is reference in Stephen's code,
txtBackGround, and bring it to the front the form acts funny. When I send
txtBackGround to back the form works as expected.
I've done some research on "bring to front" and "send to back" but have not
found much at this time.
Thanks again,
--
Rick Allison
> >I took Stephen's CustomerInContinuousView form and added three new text
> >boxes. I left the record source the same and tested the form. It worked as
[quoted text clipped - 17 lines]
> Marsh
> MVP [MS Access]
Marshall Barton - 16 May 2005 22:38 GMT
>What's the difference between "Bring to Front" and "Send to Back"? Can
>these be controlled programmatically?
[quoted text clipped - 5 lines]
>I've done some research on "bring to front" and "send to back" but have not
>found much at this time.
Bring to Front and Send to Back are how you can manipulate
what's called the Z-order ov the controls. There is no way
to do that manipulation at runtime.
The control that's used to display different backcolors must
be in the back, behind the text box with the Transparent
BackStyle.
You might want to create a test form and play around with
this a little just to get a feel for how it all fits
together. Once you get a grip on these properties, you'll
find that there's nothing mysterious about it.

Signature
Marsh
MVP [MS Access]