Report "Control Source" Build Expression Box doesn't work/works

[DogmaDot]

I frequently rather than use individual field names, i.e., LNAM and FNAM,
like to create a text box and enter "=[LNAM] & ", " & [FNAM]". However, when
I go to that field on the Property Sheet for that new text box, and Right
Click, or Left Click to get the BUILD dropdown, I get thrown out of ACCESS.
(with the attendant message to send to MS - which I usually don't do as I
have NEVER gotten an answer from MS about ANY problem.) I know I can type
the expression onto the line, but sometimes the expression is more complex,
taking up a lot more room or it uses field names which need to be typed in
from scratch. I did this all the time in ACCESS 2003, and sometimes - maybe
once out of 20 times it will work for me on 2007, but I've gotten thrown out
of ACCESS so many times I'm beginning to feel it's something personal! Of
course trying to get help from MS is unbelievably expensive - I don't want to
pay $ 100's for a piddling little question.

 

[John Spencer]

No answer for your problem.

A bit of an explanation though. Reporting the information to MS, sends the
information into a database. The database is then used to examine the
frequency of the errors and contains some information on the state of the
computer at the time of the incident. My understanding is that MS looks at
the frequency and severity of the reported incidents to prioritize fixes. You
don't get help directly.

You are using Access 2007, but have you applied the updates to it? There are
at least two updates that have been published.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County