Label Wizard vs Bound Data

[adario]

I've created, through the Label Wizard, a label that includes a field that holds 'bound data'. The 'bound data' field works well in other reports that do not include the field in an expression.

Is there a way of including a bound data field in an expression and having the correct information (not the primary key) show up?

tks,
Amy

 

[rwpetrie]

Are you using the "Bound Data"s correct "Name" in the Properties? This will be different than the Label Name itself. Be sure the expression includes this name EXACTLY

 

[adario]

Yes. I think it has something to do with the info being included in the TRIM expression.

tks,
Amy

 

[Pat Hartman]

When the wizard creates forms/reports it names the control with the name of the column from the recordsource it is bound to. You need to change the control names so they are different. In my databases, I just add - txt - to the beginning of each control name. So - CONTRACT_NUM is the column name from the recordsource and txtCOLUMN_NUM is the control name. Access gets confused when you try to do things in code when the two names are the same.

 

[adario]

Thanks...

Amy