cr + lf in form field stopped working

  • Thread starter Thread starter MarkMurphy
  • Start date Start date
M

MarkMurphy

I was using the following in a form field. After upgrading to Office
2003, it started giving me the #Name? error.

=[Street Address] & Chr$(13) & Chr$(10) & [City] & ", " & [State] & "
" & [Zip]

Anyone know what changed?

Thanks!
 
Hi Mark,

Thanks for posting in the community!

From your description, I understand that after you upgraded to Access 2003, you received
#Name? in a form field. I agree with Van that this may be a Reference Errors. Please read
the article carefully to make sure if it addresses your problem and sovle it after avoiding the
reference issues.

Additionally, it is also recommended that you manuailly update your Jet engine to Jet SP8
after you upgrade to Access 2003.

829558 Information About Jet 4.0 Service Pack 8
http://support.microsoft.com/?id=829558

Another consideration is to change the Macro security to "Low" (Tools->Macro->Security),
or change the SandboxMode if you met with the problem described in the following article:

294698 HOW TO: Block Unsafe Visual Basic for Applications Functions in
http://support.microsoft.com/?id=294698

Mark, please apply Van's suggestion as well as mine and let us know if they help resolve
your problem. If there is anything more we can do to assist you, please feel free to post it in
the group.


Best regards,

Billy Yao
Microsoft Online Support
 
Thanks for the responses. The references tip did the trick. The Jet
patch has been applied too.

-Mark
 
Back
Top