Conditional Formatting "#name?" problem

[DataMiner]

I have an unbound form with some unbound controls where the control source is set to something like

=dmax("MyField","MyTable","Item='MyItem'")

This has worked fine for a long time, until today, when I tried to implement some conditional formatting on these controls. Now, half of them are returning "#Name?" instead of a value. Even after I delete the conditional formatting, they still do this. The only way I can get the correct value back is to recreate the control from scratch.

I understand why conditional formatting might not work with domain aggregate functions, if the formatting is trying to use the field value before the function has returned a value. Has anyone else had this problem?

Access 2002.

 

[ColeChaW]

Hmmmmmm

Don't know if this will help, but I found when Access autogenerates text boxes it names them after the field you're using. So if you have a "Price" field then the name of the textbox is 'Price.'

This then would create an error like you described if you try to the word 'price' in your equation, Access won't know if you mean the textbox or the field. Make sure your text box is set to something like 'txtPrice' so you won't encounter this error.

Or maybe that's just something I had trouble with, if that's not helping we can try something else.