Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / February 2006

Tip: Looking for answers? Try searching our database.

Access in Office 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Angela Coventry - 28 Feb 2006 11:40 GMT
I have update my client listing in access and when I print off the report is
shows 'error' in the contacts first names - is there a way of changing this
so that the first names are listed in my report
Jerry Whittle - 28 Feb 2006 14:27 GMT
Hi,

Open up the report in Design View. Right click on the First Name text box.
Bring up the Properties. At the top of the All tab, what does it say for the
Name and Control Source? Does the Control Source match a field in the table
or query that drives the report?

Could the First Name text box have something like the following in it?
=UCase([First Name])

If so it is not a recognized function, has the wrong arguments, you have a
references problem, or the Name of the text box is the same the field in the
Control Source. The last is a very common problem. It that case, change the
name of the text box to something slightly different like txtFirstName.

By default Access uses the name of the control source for the name of the
text box control. Works great until you start messing with things then Access
gets confused and shows errors. I usually change all my text box names by
adding txt, dt, num to them so as to prevent such errors.
Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have update my client listing in access and when I print off the report is
> shows 'error' in the contacts first names - is there a way of changing this
> so that the first names are listed in my report
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.