Concat. text, field in group heder?

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

Hello,

Is it possible to concatenate text and fields in an MS
Access report's group header? When I use the following
test:

=[ConsortiumName] & " test"

I get an "#Error" message?

Thanks in advance for your help.
 
Thanks. I expect that you're probably correct.
Apparently the important thing is to make sure that Access
recognizes the distinction between the name of the control
and the names of the fields in the control.
-----Original Message-----
Definitely - Your example may need something like...

=Forms!YourForm!ConsortiumName & " test"

HTH - Bob
-----Original Message-----
Hello,

Is it possible to concatenate text and fields in an MS
Access report's group header? When I use the following
test:

=[ConsortiumName] & " test"

I get an "#Error" message?

Thanks in advance for your help.
.
Click to expand...
.
Click to expand...
 
joe said:
Thanks very much. This works. (I wonder why.)
Click to expand...

Because the text box control and the data field are two
different objects. If they're named the same, then what you
meant is ambiguous and the Access programmers thought it
made more sense to use the control (it's too bad they
defaulted the two objects to have the same name in the first
place). Unfortunately, in your case, you end up with a
control that refers to itself, which is a circular reference
and hence an error. Making the name of the control
different from the name of the field removes the ambiguity
so there's no problem.

Interesting to note that when you change the name of the
text box, MS Access 2000 automatically updates the same
string elsewhere in the control to match the new name of
the text box. So you have to restore that to the original
name to maintain the difference between the field name IN
the text box and the name OF the text box.
Click to expand...

Here's another half baked solution to a perceived
defficiency - the Name AutoCorrect feature. This option
should be disabled using the Tools - Options menu item -
General tab - Track name Autocorrect info check box.
 
Back
Top