"Brenda" wrote in message
...
<snip
: Then I wanted to format my header and created a macro to see the code.
Ended
: up with this
: .CenterHeader = "&""Arial,Bold""&12Collateral Import"
:
: How do I take the formatted header, but still use the variable DBID_Name
in
: in place of the literal Collateral in the header? I can not get the syntax
: correct.
:
: Brenda
:

try
..CenterHeader = "&""Arial,Bold""&12" & DBID_Name & " Import"
Paul D