B
bird lover
I work with access and excell 2003. If cell in excell contains data as
follows:
Mary Smith
Long Beach
John James
Los Vegas
Then upon import or linking spreadsheet into access, a little square pops
in. This creates havoc in formatting, when I do a mailmerge between access
and Word.
I don't know programming, vba, sql or anything fancy.
Using an update query for field [people] what is the syntax to lose the
square and replace with appropriate carriage return and/or line fees.
PS. I looked at an article at http://support.microsoft.com/kb/210372 but
access wouldn't accept it.
follows:
Mary Smith
Long Beach
John James
Los Vegas
Then upon import or linking spreadsheet into access, a little square pops
in. This creates havoc in formatting, when I do a mailmerge between access
and Word.
I don't know programming, vba, sql or anything fancy.
Using an update query for field [people] what is the syntax to lose the
square and replace with appropriate carriage return and/or line fees.
PS. I looked at an article at http://support.microsoft.com/kb/210372 but
access wouldn't accept it.