Control Source in Reports question.

[Craig Armitage]

Hey again guys,

Why is it that some fields behave differently in reports than others?

I have 2 fields in a table. one called Customers_BusinessTown and one
called Customers_HomeTown. Both have identical properties.

if i have a textbox with =Customers_HomeTown as the control source then i
get #error with no explanation why. Yet if i use =Customers_BusinessTown
it is fine. If i dont use the = sign then both work fine but i need to set
an =IFF function so i really need the =


Thanks in advance..

 

[Craig Armitage]

Aha,

its ok, i figured it out..There was another object that had the same name..
this was causing a conflict..

 

[Van T. Dinh]

Yes. I think the Report Wizard creates Control (Textboxes ...) with the same
names as the binding Fields and this can create problems when you use them
as Calculated Controls. I tend to go through and rename Controls by adding
appropriate prefixes, e.g. "txt" for TextBox.