If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access in Office 2003
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 |
#2
|
|||
|
|||
Access in Office 2003
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. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Angela Coventry" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 vs. 2003 | Neil | General Discussion | 52 | February 16th, 2006 10:18 PM |
Four KBs to address problems epidemic, ubiquitous and replete | Rick | Setup, Installing & Configuration | 1 | August 19th, 2004 05:14 AM |
Error #1321 MOS 2003 Setup | Chad Harris | Setup, Installing & Configuration | 1 | June 7th, 2004 12:22 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
MSI installer runs when I run Office 2003 app | Ralph Sharett | Setup, Installing & Configuration | 1 | May 27th, 2004 07:58 AM |