Cannot use trim - Control has a reference to itself

[tstoneami]

I have a several text fields in a table which I can successfully use the =Trim function on. I have a number of others in the same table of the exact same type and size - no differences that I can detect - where I get a "control has a reference to itself". If I preview the report, I see a #Type! entry in the output.



I've looked around quite a bit and can't find a relevant reason, although I am sure it will be obvious to more experienced folk around here.

Any insight immensely appreciated. FYI if I don't use Trim, the interface is happy and the report runs - just not with trimmed results.

Thank you - eagerly waiting...

Troy

[pbaldy]

Likely the textbox has the same name as the field, which can confuse Access.

[tstoneami]

Bingo. Of all the things I exhaustively looked at, the most obvious was overlooked. THANK YOU PBALDY!

[pbaldy]

No problem! That's a pet peeve of mine. The wizards all name controls that way, then if you do anything different, the program barfs. Doesn't seem like it would be difficult for the wizards to use a naming convention of some sort that would avoid the issue.

[tstoneami]

How do we mark these as solved? Is that important to do that? I have another thread that is solved also.

Again, thanks -

[pbaldy]

Marking as solved can be helpful. It's under Thread Tools at the top of the thread.