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

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?
 
D

Douglas J. Steele

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access 2007 Can Grow Not Working 0
Problems with carriage return in address field 5
Populating Address fields in form 3
Why am I still getting data??? 3
Access 2007 Runtime questions 3
Getting Line Feeds to Display 1
Code to add a carriage return to a memo field in a form 3
2 questions: DLookup and Chr(13)/Chr(10) 2

Top