Where should I ask questions relating to the Access 2007 Runtime?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Access 2007 app that has a form with a text box that includes a
number of fields for presentation purposes.

=[Address] & Chr$(13) & Chr$(10) & [City] & " " & [State] & " " & [Postcode]
& Chr$(13) & Chr$(10) & [CountryName]

In access 2007 I get a nicely presented 3 line Address block..
In Access 2007 Runtime I get "#Name?"

I have tried without the $'s but same problem - other than Access 2007 will
only display the fields without the carriage returns.
Thoughts?
 
It could be a problem with the References collection due to a difference in
version or location of a referenced file between the machine on which the
application was built and the client machines.

You might be able to get around the problem by using VBA.Chr$(13) &
VBA.Chr$(10) rather than Chr$(13) & Chr$(10). However, that only masks the
symptoms, as opposed to solving the problem.

I talk about an approach to solve References problems in run-time
applications at http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
(although I haven't had an opportunity to update it to refer to Access
2007).
 
Back
Top